Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>Beth,
>>>
>>>>Am I going about this incorrectly?
>>>
>>>How about instantiate your CA, Call its CursorFill(.T., .T.) -- second param means no data. This gives you an empty updatable cursor. Then put your data into that cursor and call Tableupdate().
>>
>>
>>I need data to come over from server if there is any to be sure I set the primary key correctly. but I do have the first .T. there. There may or may not be data on the server.
>
>Beth, I am not sure what you asking about. What is the PK in that table and how you are make sure that the PK is not violated?
Hi Borislav,
PK is an integer. Since I bring down all records in that table, if there are any, I find the max interger and add one to it, to get the next pk. Then add one to the new number as I go through the records I have on my side of the equation (i.e. the records to be added to the table). if no records in the table from server, I change the pk in my tables starting at 1. Hope that makes cents. :-)
This is a conversion program, so most time (if not all), there should be no records in the tables I am accessing, but, just incase, the code is there.
Anyway, I finally got it working, but I am not sure exactly how, because I made many changes trying to get it to work, the last change was putting oRS.CursorLocation to client. Now things get into the tables and I was able to check it in.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement