Database question

Postby Otto » Fri Oct 26, 2007 7:25 pm

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
User avatar
Otto
 
Posts: 6332
Joined: Fri Oct 07, 2005 7:07 pm

Postby Marcelo Via Giglio » Fri Oct 26, 2007 7:49 pm

Hi,

Code: Select all  Expand view  RUN

   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
Marcelo Via Giglio
 
Posts: 1064
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Postby Otto » Fri Oct 26, 2007 8:00 pm

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
User avatar
Otto
 
Posts: 6332
Joined: Fri Oct 07, 2005 7:07 pm

Postby reinaldocrespo » Sat Oct 27, 2007 11:42 pm

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  Expand view  RUN
Try

while ok
   copy record to tempfile
   delete record
   skip
endwhile

catch
  restore records to original file from tempfile
end



Hope this helps.


Reinaldo.
User avatar
reinaldocrespo
 
Posts: 979
Joined: Thu Nov 17, 2005 5:49 pm
Location: Fort Lauderdale, FL

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 68 guests