Search results for query: *

I am sorry, but I don't understand your question. My post contains the algorithm to convert a string ("InputString" in the code) to the format that you wanted. Please substitute this with Form.AppropriateControl.value. Rajesh

Please modify the code below appropriately to suit your program. LOCAL InputString, CommaPos, i, SpacePos, PrefixString, BlNo STORE 0 TO CommaPos, i, Counter, SpacePos LOCAL ARRAY xAr[1] xAr[1] = "" PrefixString = "" BlNo = "" InputString= "CHEVSINSMZ 100, CHEVSINSMZ 100, CHEVSINSMZ 101...

RogerRuntings, In Mike's code, subsequent to the line tempString = RIGHT(tempString,; LEN(tempString)-AT(CHR(13),tempstring)- 1) include: TempString = LEFT(tempstring,RAT(CHR(13),tempString,1)-1) In the above code, it is assumed that the last line does not end with chr(13). If it does...

Hi, Probably, what you are looking for is in the 'InitChoices' and 'InitSelections' methods of the _mover class. Dimension aChoices[AvailableNumberOfSelections,1] Dimension Chosen[AvailableNumberOfSelections,1] Select srcTable Scan * Populate aChoices array from the source table endscan...

Sorry for the trouble. thread184-907075 had the answer I was seeking. Regards, Rajesh

Hello, I'm running a VFP 8 app. with a database having a connection to SQL Server DB and various views. The current forms DE contains no tables. When I 'Set Step On' in the form, the debugger opens and immediately a 'File Open' dialog is shown. Even if i select a table, the dialog persists...

Excellent work. Thanks very much. Rajesh

Graham, just in case, you may want to check the existence of the file using - if file("lu\punc.dbf") or perhaps try and read the file using Fopen(). Rajesh

Hi, We are running a VFP 7 application on our LAN and over citrix as well. Over LAN, the app. runs without any problem when I 'Add' and 'Save' a record. But over Citrix, when a new record insert is triggered by the 'Save' buttons click, the control goes back to the Citrix main window (Internet...

Update FYI.. Downloaded and installed MDAC 2.8 module, and recompiled setup.exe. This install went through without troubles on Win 98. Thanks again for the assistance. Regards, Rajesh

Mike, Thanks for your reply. As rightly mentioned by you, I'm not installing SQL server on the client. I was successful in installing a VFP8 app. on Win 95. earlier. Only, the database then, was in MS-Access. Re. SQL Server Client tools: Could you please elaborate on this as I'm quite new to...

Further to the above message- At present we cannot try installing it on an XP, WIN2K etc. So, we don't really know whether the setup will succeed in other platforms. Regards, Rajesh

Hi, Our application is developed in XP, VFP8 and with the database in SQL server. We built the 'Setup.exe' using Installshield Express 5.0. When we run try to install the app. on a Win95 or Win98 PC we get the following error: The wizard was interrupted before MACS could be completely...

Neil, In my db's sysobjects, all user-created SPs. have their category column populated with 0 and the system SP with 2. The SQL Server BOL mentions that the category column is 'Used for publication, constraints, and identity.' SELECT * FROM dbo.sysobjects where type = 'P' and category=0 or...

Good work Ramani. Thanks for sharing it with us. One more * for you. Regards, Rajesh

Mike Lewis, Thanks for your assistance. I'm not much into access. How do go about overriding the default setting in the control panel for specific date fields? As such your other suggestion of setting date to American and updating using SQLEXEC works. Thanks again and regards, Rajesh

Hi, I'm using MS-Access as my back-end & the app. is in VFP8. The application's set Date is British. Current date is "02/09/2004" When I run the following code: lnRes=SQLEXEC(Handle,"Insert into LastDone (UpdatedOn) VALUES ("+"#"+DTOC(DATE())+"#)") In Access, UpdatedOn is populated with...

Brian, Brilliant.. Thank you. * for you Regards, Rajesh

Rick, Tried your suggestion. No joy. I still get the error message: The microsoft Jet Database Engine cannot find the input table or query 'pbFunc' Thanks for your input. Regards, Rajesh

Hi, I've created a VBA Script in an MSAccess mdb. Module name: PBProcs Function in this module: PbFunc function have no parameters. The front-end is VFP and I need to run this function PBFunc from the VFP app. I've tried the following: 1. SQLEXEC(Handle, "Execute PbFunc") 2. SQLEXEC(Handle...