Database question

[Otto]

Thank you.

Could you please post some code how to open a ADT file with FW.
Is there much to change necessary to convert from dbf to ADT?
Regards,
Otto

[Marcelo Via Giglio]

Hi,

Code: Select all

   REQUEST ADS
   
   rddRegister( "ADS", 1 )
   rddsetdefault( "ADS" )

   Set SERVER <LOCAL|REMOTE>
   Set FILETYPE TO ADT //CDX or NTX

   adsConnect60( "<DICTIONARY.ADD>", <SERVER TYPE>, "<USER>", "<PASSWD>" )

   adsRightsCheck( .F. )

ADSConnect60 is used only if you are usigng dictionary, then all work in the same way, you don't need to change nothing

regards

Marcelo

[Otto]

Thank you very much.
ADS offers a free server for developers to test.
I think I will install the server and have a look.
Regards,
Otto

[reinaldocrespo]

Otto;

Transactions works in ADS with DBFs just perfectly. Without ADS you'd have to implement the logic your self. For example:

Code: Select all

Try

while ok
   copy record to tempfile
   delete record
   skip
endwhile

catch
  restore records to original file from tempfile
end

Hope this helps.


Reinaldo.