Recent content by andreateh

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