Search results for query: *

Hi NoCoolHandle, I'm planing moving my VFP to MSSQL Server. But before i move would like need some advices from your guys. In one the application required Pessimistic records locking ("Reserved Records"). Below is the field that use to reserved record: field name type locktim...

Thanks for advice,MarciaAkins.

Yup,If the program crash the lock will stay there. If the program found that both field is not empty. It will then check the lockdt as below If the value in lockdt > maxlocktime. If line above true, mean this record have exceed the maximun reserved time. And then when another user try to...

Hi ,Marcia G. Akins Thanks for fast reply. Just have one idea from my friend. But i don't know wherethere it is efficient or not, so need advice from expert :) Can i make a "soft lock" on the record ? What i mean "soft lock" is add 2 field in the location field name type lockdt...

Hi Marcia G. Akins, One more question on moving from VFP to MSSQl. Our company currently application is using RLOCK() to Lock / Reserved a record during the user doing the entry part. (Where the user will need to choose few location to store few types of goods. When user select location A...

Thanks for advice.

I', plan to move from the VFP database to MSSQL server. But i have few question before i move to MSSQL server. In VFP i used to write my single file maintainance program in a form with a pageframe with 2 pages. In page 1 contain a grid which is use to display the entire table's record. In here...

Thank for explaination. Where can i get some sample of using TRY..CATCH..FINALY that can show me "If you run into any problems anywhere in this section, log the error and skip the rest of the section". . Thanks.

I still not every clear about Try..Catch..Finally Can i just put my error handling stuff in the object.error? Like example below : in oApp.error LPARAMETERS nError, cMethod, nLine DO CASE CASE nError = 1 &&In here i will try DO xxxxx &&to put all possible CASE nError =...

Here is another: Use LOCATE Instead off GO TOP to go top the first RECORD. LOCATE is faster. From VFP help document : If you use the LOCATE command without the FOR expression, Visual FoxPro positions the record pointer at the first logical record. This is faster than using GO TOP when a...

Hi everybody, here are some tips sharing. So lets try to post our most frequnce use tips here. I think this kinda tips is very useful for beginer like me: USE EVALUATE OR () instread of & (MACRO ASSIGN) CREATE CURSOR t (cText C(3),nNumeric N(4),cText2 C(3)) INSERT INTO T...

hi rick can u give me some further detail explain on : Why not provide him a VFP COM .DLL to check this for him?

My colleague is developing a VB program to work concurrent with my current VFP program. In my program i use to use rlock() to lock a record (reserve a record,sound stupid but is user request). Now my friend want to determine or lock a vfp table record from his VB program. So i suggest he use...

Thanks for fast reply.the LockType is already set to 2 but still not working. I still able to modify the record in VFP. In the VFP Documentation, it had mention that Rlock() is support by VFP OLE DB.. by still not working.. will try to post the post to VB to try luck..

My colleague is developing a VB program to work concurrent with my current VFP program. In my program i use to use rlock() to lock a record (reserve a record,sound stupid but is user request). Now my friend want to determine or lock a vfp table record from his VB program. So i suggest he use...

Is it possible to find out a record is lock by rlock()in VFP From VB. My colleague is try to write an VB apllication to share table with my current VFP program. but he can't determine the record is it rlock by the vfp. Can some body give some comment ?

When should i use SCATTER NAME ? and what is the benifit to scatter the record data to an object ? Because i still quite new to VFP, so please some body give me some advice. thanks

From VFP document : SYS(602) - Bitmap Configuration Returns the current setting of the bitmap in the current configuration file and turns off-screen bitmaps off or on at run time. SYS(602 [, 0 | 1 ]) Parameters 0 Turns off off-screen bitmaps at run time. 1 Turns on off-screen bitmaps at...

Thanks for your advice craigsboyd. Next time i'll try to descibe my question in more detail. Actually the code u show above is just exactly like my case. the only different is CREATE CURSOR tableA (slipno I, procod I, lotnum I, curcod c(30), loc c(10), row c(10), abu c(10)) INSERT INTO...

From VFP Document : SYS(602) - Bitmap Configuration However, off-screen bitmaps use a lot of memory, so you can improve performance on Terminal Server applications by turning these bitmaps off using SYS(602). SYS(602,1) &&(Default) Is this mean by default VFP application will take up lot...