Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jrajesh
  • Order by date
  1. jrajesh

    How to trim all the words?

    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
  2. jrajesh

    How to trim all the words?

    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...
  3. jrajesh

    Delete line from text file

    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...
  4. jrajesh

    Super Mover Class usage

    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...
  5. jrajesh

    Debugger brings up 'File Open' dialog

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

    Debugger brings up 'File Open' dialog

    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...
  7. jrajesh

    Two New Visual FoxPro Functions

    Excellent work. Thanks very much. Rajesh
  8. jrajesh

    User-interface operation not allowed at this time. 1031

    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
  9. jrajesh

    VFP-Citrix - Problem adding a record

    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...
  10. jrajesh

    Installation Error

    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
  11. jrajesh

    Installation Error

    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...
  12. jrajesh

    Installation Error

    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
  13. jrajesh

    Installation Error

    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...
  14. jrajesh

    How do you spot a user created SP in MSSQL?

    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...
  15. jrajesh

    You can select your Thermometer or Progress Bar Class

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

    Incorrectly updating MS-Access date field

    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
  17. jrajesh

    Incorrectly updating MS-Access date field

    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...
  18. jrajesh

    Running a VBA Script in MS Access from VFP

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

    Running a VBA Script in MS Access from VFP

    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
  20. jrajesh

    Running a VBA Script in MS Access from VFP

    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...

Part and Inventory Search

Back
Top