Search results for query: *

Finally, I choose myToolbar as the object to hold the cursor. Many thanks for all of you. Arthur Liu(Shanghai, China)

Hi Tamar When the form is released, the DE would be destroyed too. For the native VFP table or cursor, however, if DataEnvironment.AutoCloseTables is set to false, the cursor can keep using. My purpose is that after downloading the data from server and handled in form A. The clients can do...

Thanks Mike. But myForm.DataSession is set to 1 (Default Data Session) I'm worried is there any coding wrong. In myform.load, I write: IF USED("myCursor") REQUERY("myCursor") ELSE thisform.DataEnvironment.NewObject("myObject", "myCAClass") thisform.DataEnvironment.myObject.CursorFill()...

Thanks Pamela, But I want to know what kind of entity I can choose to bind with CA instance other than FORM. Arthur Liu (Shanghai, China)

Another question, how can I keep the cursor (which is created from CA) opened after the form is released. I set the DE.AutoCloseTables to false, but it does not work. Thanks Arthur Liu (Shanghai, China)

Thanks In myForm.Load method, I write thisform.AddProperty([MyCursor]) thisform.MyCursor = NewObject([MyCAclass],[CAClassLib]) thisform.MyCursor.CursorFill() It works. Many thanks Arthur Liu (Shanghai, China)

I buildup my own CursorAdapter class, I can use them like the following code in DataEnviroment.OpenTables method: this.AddObject("o", "myCursorAdapter") It works fine. But how can I apply it in the myForm class, because classes doesn't support DE. There is same question for toolbar or menu...

Thanks Borislav Clearly explanation and good suggestion, I give you a star. Next step, I will learn CA. Arthur Liu (Shanghai, China)

Hi I'm a beginner with SQL2000. I have some questions about DATE field. 1 When I leave the date field blank, it returns '01/01/1900 00:00:00' after requery(). I'm using remote view and binded the cursor in the grid. How can I avoid this situation and just return ' / / ' like in VFP. 2 Some...

Mike It works. Thank you for your great help. Arthur Liu (Shanghai, China)

Mike Thanks for your great help. I found the reason. The primary key "idnbr" is set to INT IDENTITY in the server and will be auto increased. When adding a new record, after TABLEUPDATE, the field "idnbr" is affected on the server (auto increased), but the value of the new added "idnbr" in local...

Hi Mike I just assume the end user will add a new record and delete it immediately. I put these two function (Add and Delete) in one question in order to easy to read. Thanks for your advise, but I use the SPT not remote view. Do you mean I have to SQLEXEC("SELECT ...") again, because REQUERY()...

Borislav Borissov Thanks for your prompt reply. TABLEUPDATE is fine. Arthur

I don't understand where is the update conflict. The code is as follows: SCATTER NAME oFieldValue MEMO FIELDS EXCEPT timestamp_column, idnbr APPEND BLANK GATHER NAME oFieldValue MEMO REPLACE curEmployee.name WITH ALLTRIM(curEmployee.name) + "-COPY" IN curEmployee lcAlias = "curEmployee"...

Thanks Mike When I first learn VFP, I read very line of the sample APP 'Tastrade' in the VFP installed path. And then I write my own APP almost 9M, it works well when it's only 10 users (using 'USE mytable SHARED'). Now I will have 50 users, I have to choose SQL and rewrite my codes. My...

Hi I'm a beginner for SPT. Does anyone can help where I can find out the sample codes including navigate, add, edit and delete, just like the 'Tastrade' in the VFP. Many thanks Arthur