Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
>>>>>What are you trying to do? Cursor adapter should be able to work with anything that has ODBC driver or OLE DB provider.
>>>>>
>>>>>>
>>>>>>Is there any sample code for use cursor adapter with flat text file?
>>>>
>>>>I just want to insert-update-delete from a SDF type text file. I found connection strings from Google but couldn't understand the correct typing. says path and extension. When I try to select with a cursor name will it search a text file from that folder with that extension?
>>>
>>>Metin,
>>>
>>>I often have to work with other peoples data. Most of the cases I found it best to create a vfp cursor or table from the data given, check if some clean up processing needs to be done and then move that data into the intended target tables via SQL. The vfp import wizard sometimes is helpful, other times I just create a cursor definition in the command window.
>>>
>>>Having discrete stages is helpful the first time you find something weird which needs to be corrected ;-))
>>>
>>>my 0.02€
>>>
>>>thomas
>>
>>Thank you Thomas, but it's not an SQL case. I should update a text file. Currently I do this with fopen fwrite fclose. But sometimes ocrur some overflows, I know there is a bug buth may be change with a cursor adapter more easy way...
>
>Even then you read in the file into a cursor, manipulate it there and send out the changes.
>Not much different from reading in the whole file into a table, doing the needed changes and copy the whole file out again.
>As max file is 2GB, not that much time even in worst case ;-)
I just already did this for escape from my buggy code. I just thought if cursoradapter doesn't work like me might be faster. Actually file is not bigger than 300-500kb...
Précédent
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