Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I get an error I cannot explain
Message
From
22/05/2006 05:47:43
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01123880
Message ID:
01123885
Views:
22
Yes, I'm using an IDX because I have to connect to old fashioned dbf tables.
Thanks for the advice... i'll change the select sentence.

>:-)
>From previuos post I see that you didn't need of Clienti at all:
>Just change
>
>* from:
>      where contatti.codcli == clienti.codcli ;
>        union ;
>          .....
>            where agenda.codcli == clienti.codcli and Empty(idc);
>          ......
>*to:
>      where contatti.codcli == wanagraf.CODCLI ;
>        union ;
>          .....
>            where agenda.codcli == wanagraf.CODCLI and Empty(idc);
>          ......
>
>
>Also, are you using IDX instead of CDX? I ask becuase of that line:
>
>Set Index To 'clienti1'
>
>
>
>>I got through the error with the Try...endTry set of instructions :
>>
>>	Try
>>		If !Used('clienti')
>>			Use clienti Again In 0
>>		EndIf
>>	Catch to oErr
>>		If oErr.errorno = 9
>>			If !Used('clienti')
>>				Use clienti Again In 0
>>			EndIf
>>					
>>		EndIf
>>	Finally
>>		If Empty(Sys(14,1,'clienti'))
>>			Select 'clienti'
>>			Set Index To 'clienti1'
>>		EndIf 	
>>	EndTry 	
>>
>>
>>Now it goes on without errors but I don't like this solution very much...
Previous
Reply
Map
View

Click here to load this message in the networking platform