Search results for query: *

Hi. I've got a mail merge doc where almost all the merged numeric fields show decimal points after I perform a mail merge (i.e., "3."). I am using Word 2002, SP3. I am using an Access file to do the mail merge. The numeric fields have zero decimal places. I have other mail merge docs that do...

With the SQL commands: DROP FUNCTION CREATE FUNCTION DROP VIEW CREATE VIEW And the option to specify EXTERNAL objects -- Is there a way to specify a library for each (i.e., CREATE FUNCTION MYLIB/MYFUNC), without having to do it on the CREATE, etc. statements? I see where that you can create...

This is weird. I created the following function in STRSQL: CREATE FUNCTION PGMRUTOOL/BBFLSTSTS (APPYER DECIMAL(2,0), APPNBR DECIMAL(8,0)) RETURNS CHAR(60) LANGUAGE RPGLE NOT...

Sorry for the bother. I have an SQLRPGLE based service program that "works" when called from an RPGLE based program, but when the same service program is wrapped in an SQL function, then used within STRSQL it fails with a data decimal error. I don't know how much info would be sufficient...

Racking my brains on this (would be most greatful for the help): Created an AS/400 SQL function that I created from an RPGLE service program, but when I go to run the function through a select, I get the following error -- BBFAPPSTS in *LIBL type *N not found The function was created from the...

I have a macro in a Word 2000 document that does a few things (partly of which) -- * Creates a blank document. Documents.Add * Inserts between two and ten documents into it. Selection.InsertFile FileName:=PlanCheckCoverDoc, Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False...

Have noticed that the aggregate Last function is pretty useful. But is there a way around it, using standard SQL? With last, I can do something like this -- Select tblGame.BaseBallPlayer, Last(tblGame.Hits), Last(tblGame.AtBats) From tblGame Group By tblGame.BaseBallPlayer

Sorry if this has already been posted. Search feature not working. A link to the proper thread would be cool. I'm trying to determine if sharing a workgroup is possible between databases. Let's say I have an Access 2000 database, db1, and I have created a workgroup called db1wg and placed it...

I have gotten a curious error with my IE 6 browser ever since being invaded by the AproposClient virus -- When ever I try to navigate to a non-existant domain, I get a web page that reads -- "Search the Web - Incorrect Error Page" This web page has some sort of search input field...

Can't seem to find the method for doing this. I've got this ibm reference -- http://as400bks.rochester.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AQ902/CCONTENTS and have searched in vain for the following -- How to update a table's column with values from another table. That is, for each record...

I'm a newbie to FrontPage, but interested in doing things "right". Is there a best practice when it comes to the use of the _private folder? According to this link -- http://www.fcs.iastate.edu/computer/tips/frontpagetips/nobrowse.htm "The _private folder is the proper place...

How common is it for software vendors to charge maintenance fees in the first year of software usage? (Pardon if this is the wrong forum.)

I have a six-digit date field (BPADAT) defined as: * Data Type Number, * Field Size Number, * Precision 6, * Scale 0 (in YYMMDD format). I'm looking for the simplest way to convert the date in a query to a Date/Time field (BPADATDT). Unfortunately, the simplest way that I can think possible is...

Novice SMS users, here: Been told that SMS cannot reboot a Windows 95 client and return to remote controlling (if that makes sense). Is that true?

I just need confirmation: My experience has shown that bookmarks don't work well with non breaking spaces (those inserted by control+shift+spacebar). I have a bookmark called LASTDATE. It get's found/replaced with a date spelled out as month-name day, year. (Example: January, 1st, 2003.)...

I have a table that has amongst it columns the following -- * An action date, * A transaction date, and * A transaction time. How would I find the last transaction date / transaction time combination for a particular action date? I have one method where I select on the MAX (of the concatenated...

Auto-correct does not seem to work with Captions on my version of Word 2000. Missing feature or missing service pack?

Let's say you have an ODBC DSN setup for a particular SQL Server 2000 database. Is it a good common practice to connect to that data within Crystal Reports, when setting up a Crystal Report? (I.e, "Data Explorer -> ODBC DSN -> Appropriate Table")? As opposed to connecting to the...

Please let this be a basic question that anyone can answer accept me: How can I connect to an SQL Server 2000 through the "Data Explorer -> More Data Sources -> Microsoft SQL Server" link? I don't see any SQL Servers listed for me. And when I specify one from the Microsoft SQL...

I can't seem to find it. And I can't seem to assign one to it.