Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jestin1979
- Order by date
-
Blank instead of .Null. on append from SQL (VFP 6)
Sorry, the Nulls in SQL are OK.- jestin1979
- Post #12
- Forum: Microsoft: FoxPro
-
Blank instead of .Null. on append from SQL (VFP 6)
The blanks in SQL are by OK. They are part of an online form that can be filled in, but don't need to be. They are then brought down to a VFP table, then read into a screen. On this screen I want blank values if the website user didn't fill anything in. The fields in the FP table are not...- jestin1979
- Post #11
- Forum: Microsoft: FoxPro
-
Blank instead of .Null. on append from SQL (VFP 6)
To clarify another point, when I run my FP program, I get an error saying the field doesn't accept NULL values.- jestin1979
- Post #9
- Forum: Microsoft: FoxPro
-
Blank instead of .Null. on append from SQL (VFP 6)
Dan is correct; I'm having the problem of nulls in sql, but wanting blanks in FP. I'm using SQLEXEC to bring it into a local cursor, then appending to a table from that cursor. Just after posting this I found the BLANK command. What I'm thinking of doing is an ISNULL in the sql to set the...- jestin1979
- Post #8
- Forum: Microsoft: FoxPro
-
Blank instead of .Null. on append from SQL (VFP 6)
There is a table on SQL Server that I'm trying to bring down to an FP table. The table doesn't allow nulls in a couple of numeric fields, but in SQL they are NULL. If I append a blank row, and fill this row out by hand, I could leave these non-nullable fields alone and the row would save, Even...- jestin1979
- Thread
- Replies: 12
- Forum: Microsoft: FoxPro
