Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Offline Views
Message
From
23/04/1999 09:27:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00210083
Message ID:
00211472
Views:
25
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
Previous
Reply
Map
View

Click here to load this message in the networking platform