Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seeking a brilliant idea to replace NextID() function
Message
De
21/01/2008 12:41:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01283680
Message ID:
01283727
Vues:
16
>>Borislav,
>>Stealing your code (be informed) for other parts of this and will modify to suit my needs:)
>>Probably I couldn't explain my need well. I don't want to check and update child tables too. Mostly because it's too much work and perfromance would suffer. I simply want to know the key before insertion and submit as updatable to backend, or let backend assign one when I don't supply.
>>Cetin
>
>Be prepared. That code is only tested with SQL Server :-)
>In UpdateCursors method of the class I replaced newly received ID in all child tables.
>
>I have 5 child tables in that class, so I must do this in the FrontEnd or write SP for each Child table. Of course I have small amount of records in each table (10 - 30), sending 5*30*4 = 600 bites is not a big deal. Even working with a terrible NET (4-6K per sec) it works well.
>
>BTW I am not sure that CA sends only modified fields to the backend (never tested it though).

Oh no problem just would check for portions, I think I have started to shape a fast algorithm in my mind and implement if I don't forget before writing all:)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform