FiveTech Software tech support forums

Antonio I inserted the index code and got a run-time error : TRY SELECT 1 USE (AllTrim(cDbf)) VIA "ADORDD" TABLE AllTrim(cTable) SQL ; FROM AllTrim(cFrom) USER AllTrim(cUser) PASSWORD AllTrim(cPsw) * SET INDEX to USERID CATCH oERR MsgInfo( "Error in Opening USERINFO table" ) oDlg:End() RETURN(.F.) ...

... Security=SSPI;Data Source=EMAG\Emag;Initial Catalog=Ecmp", adOpenForwardOnly, adLockOptimistic ) //--- Source is the IP or DNS name of the server cFROM := "EMAG\Emag" // not a servername .. looks like a folder cUSER := "???" cPSW := " PASSWORD " // will get alltrimmed cDBF := "ECMP" cTable := ...

... indexes in MS SQL seem to be a bit 'sticky' as of yet .. I am sure Antonio will find a solution. Rick Lipkin #INCLUDE "ADORDD.CH" REQUEST ADORDD cFROM := "xxx" cUSER := "xxxr" cPSW := "xxx" cDBF := "test" cTABLE := "USERINFO" TRY SELECT 1 USE (AllTrim(cDbf)) VIA "ADORDD" TABLE AllTrim(cTable) ...

Rick,

>
Select 1
USE (AllTrim(cDbf)) VIA "ADORDD" TABLE AllTrim(cTable) SQL ;
FROM AllTrim(cFrom) USER AllTrim(cUser) PASSWORD AllTrim(cPsw)
>

Yes

>
then reference my vars with cWhatever := a->whatever and then write them back like a->whatever := cWhatever ?
>

Right

... vars and how do I write them back .. can I do something like : Select 1 USE (AllTrim(cDbf)) VIA "ADORDD" TABLE AllTrim(cTable) SQL ; FROM AllTrim(cFrom) USER AllTrim(cUser) PASSWORD AllTrim(cPsw) then reference my vars with cWhatever := a->whatever and then write them back like a->whatever ...

... = ALLTRIM(cHbl)+".TXT" hCts = FCREATE( cMsgfile, 0) FWRITE( hCts, cMsg ) FCLOSE( hCts ) // Send email... IF ! EMPTY( cTo ) cCmd := "mailer " + cFrom + ' ' + cTo + ' ' + cSubject + ' ' + cMsgfile + ' ' + cCClist WaitRun( cCmd, 2 ) ENDIF ENDIF cSay := "Resetting RCACTNR " + cOverseas + " - " ...