Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Error 1884
Message
From
05/04/2016 08:28:36
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
05/04/2016 08:22:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01634277
Message ID:
01634310
Views:
26
I understand this approach.

There is nobody dealing with the tables. And if - I get paid to solve it. :)

>I meant something like
>
>
>select count(*) from (calias) where cTAG=tcKey and deleted() into array laDel
>if laDel[1]>0
>*** uncertain how your code best fixed to assumptions
>endif
>IF !SEEK(tcKey,cALias,cTAG)
> INSERT INTO ...
>ELSE
> REPLACE ...
>ENDIF
>
>
>or
>
>
>lcdele = set("DELETED")
>set dele off 
>IF !SEEK(tcKey,cALias,cTAG)
> INSERT INTO ...
>ELSE
> REPLACE ...
>ENDIF
>if lcdele=="ON"
> set dele on
>endif
>
>
>as a table never is safe from others fiddling with it.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform