afrausto
Posts: 66
|
| Posted: 09/09/2005, 9:17 AM |
|
Hello,
One of the fields in my editable grid is marked as unique. Although when I test the page out to see what happens when no data has been entered in any of the fields of the 10 empty rows, it gives me the following error message: (Note:Records per page is set to 0, I only want users to insert records and not edit them)
Source: CCDLookUp function
Command Text: SELECT COUNT(*) FROM TurtleTrack WHERE GPS Name=Null
Error description: Syntax error (missing operator) in query expression 'GPS Name=Null'. (Microsoft JET Database Engine)
And then within each grid row the following error appears:
The value in field GPS Name is already in database.
How do I get it to ignore NULL entries. I can't make the field required, because I'm showing 10 empty rows. And the person entering data may not necessarily need to use all 10 empty rows at one time.
Any suggestions?
Thanks in advance
Albert
|
 |
 |
DonB
|
| Posted: 09/09/2005, 8:21 PM |
|
The correct expressions are "GPSName IS NULL" or "GPSName IS NOT NULL" The
equality operator cannot be used with NULL.
And if it's really GPS _blank_ Name, use [GPS Name] for the column.
--
DonB
http://www.gotodon.com/ccbth
"afrausto" <afrausto@forum.codecharge> wrote in message
news:64321b597e1a68@news.codecharge.com...
> Hello,
>
> One of the fields in my editable grid is marked as unique. Although when I
test
> the page out to see what happens when no data has been entered in any of
the
> fields of the 10 empty rows, it gives me the following error message:
> (Note:Records per page is set to 0, I only want users to insert records
and not
> edit them)
>
> Source: CCDLookUp function
> Command Text: SELECT COUNT(*) FROM TurtleTrack WHERE GPS Name=Null
> Error description: Syntax error (missing operator) in query expression
'GPS
> Name=Null'. (Microsoft JET Database Engine)
>
> And then within each grid row the following error appears:
>
> The value in field GPS Name is already in database.
>
> How do I get it to ignore NULL entries. I can't make the field required,
> because I'm showing 10 empty rows. And the person entering data may not
> necessarily need to use all 10 empty rows at one time.
>
> Any suggestions?
>
> Thanks in advance
> Albert
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
afrausto
Posts: 66
|
| Posted: 09/11/2005, 8:56 AM |
|
Donb,
Thanks for the help. That worked. I'm believe when you use Unique for a field the Command Text above is generated by CCS, what I often forget to do is enclosed field names with brackets. That, I believe is what triggered the error.
Thanks again.
|
|
|
|
|
