Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Offline Views
Message
De
23/04/1999 09:27:19
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
Titre:
Divers
Thread ID:
00210083
Message ID:
00211472
Vues:
23
Backend is VFP :) Purpose to support mobile staff. Maybe I should drop the idea of remoteview and use local. I was insisting on using remoteview because I try to make this a generic routine for mobile support. I didn't use the null in the same manner thinking base table might not be set as accepting nulls. For now I'll stop to bent more and code separately for each :)
Cetin

>Cetin,
>
>It seems to me that your problem is really related to the remote view, not to the fact that you've taken it off line. What is the back end for the view (VFP, SQL Server, Access)? I've found that in many cases back ends can't accept empty fields for certain types. What I do is very similar to what you're doing except that I put a null in the field if it's empty. Like this:
>
>for ix = 1 to fcount()
>  if empty(eval(field(ix))) and type(field(ix)) $ "MDT"
>    REPLACE (field(ix)) WITH NULL
>  endif
>endfor
Ç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
Répondre
Fil
Voir

Click here to load this message in the networking platform