Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing FRX/FRT to SQL Server database?
Message
De
10/02/2006 09:34:23
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
09/02/2006 16:56:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Database:
MS SQL Server
Divers
Thread ID:
01095266
Message ID:
01095438
Vues:
15
>Colin,
>
>If we took this approach of saving each of the records in the FRX to records in SQL Server, we would add a PK, an identifier for which report it is, and some kind of seqnum to allow us to query the records back out of SQL Server in the same order -- in case the record with printer info has to be the first record (not sure about that). That way, we'd have just one table in SQL Server to handle all of the reports (there are thousands).
>
>After querying into a table, would then have to get the table and memo file named correctly (instead of DBF/FPT)

Not necessary - use any table, copy to whatever.zzx, and its memo will automatically be named whatever.zzt. Fox recognizes the x as the last character of an extension and replaces it with a t for the memo file.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform