Board index » delphi » Not sure what I'm doing :)

Brent

Delphi Developer
Thu, 03 Jun 2004 10:50:13 GMT

Not sure what I'm doing :)

I'm trying to set some variables using:

MyVariable := qry.FieldValues['myfieldvalue'];

However, if 'myfieldvalue' is NULL I get an exception...is there a way
around this other than in the SQL statement itself. My goal is that even if
the value is NULL I can replace it with my own text (i.e. Not Available). I
tried an if statement but that too raised an exception. All I know to do at
this point is maybe a try but I don't think that would work either.

Help!! Thanks in advance!

-Brent

 
Guillermo Casta?o

Delphi Developer
Thu, 03 Jun 2004 11:11:23 GMT

Re:Not sure what I'm doing :)


Use qry.FieldByName('yourfieldname').AsString
or AsInteger, or AsFloat, etc...
You can also check if the field is null:
if qry.FieldByName('yourfieldname').IsNull then
    ...
bye

Quote
Brent wrote:
> I'm trying to set some variables using:

> MyVariable := qry.FieldValues['myfieldvalue'];

> However, if 'myfieldvalue' is NULL I get an exception...is there a way
> around this other than in the SQL statement itself. My goal is that even if
> the value is NULL I can replace it with my own text (i.e. Not Available). I
> tried an if statement but that too raised an exception. All I know to do at
> this point is maybe a try but I don't think that would work either.

> Help!! Thanks in advance!

> -Brent

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com
Jaap Versteeg

Delphi Developer
Sat, 05 Jun 2004 21:03:50 GMT

Re:Not sure what I'm doing :)


Why not use the 'try' ? That'll work

Jaap Versteegh

Quote
> I'm trying to set some variables using:

> MyVariable := qry.FieldValues['myfieldvalue'];

> However, if 'myfieldvalue' is NULL I get an exception...is there a way
> around this other than in the SQL statement itself. My goal is that even
if
> the value is NULL I can replace it with my own text (i.e. Not Available).
I
> tried an if statement but that too raised an exception. All I know to do
at
> this point is maybe a try but I don't think that would work either.

> Help!! Thanks in advance!

> -Brent

David Farrell-Garci

Delphi Developer
Mon, 07 Jun 2004 07:49:21 GMT

Re:Not sure what I'm doing :)


FieldValues does not check for NULL.  You will need to check it yourself or
use FieldByName.

Quote
"Brent" <bsc...@usipp.net> wrote in message news:3c1c0d1e$1_1@dnews...
> I'm trying to set some variables using:

> MyVariable := qry.FieldValues['myfieldvalue'];

> However, if 'myfieldvalue' is NULL I get an exception...is there a way
> around this other than in the SQL statement itself. My goal is that even
if
> the value is NULL I can replace it with my own text (i.e. Not Available).
I
> tried an if statement but that too raised an exception. All I know to do
at
> this point is maybe a try but I don't think that would work either.

> Help!! Thanks in advance!

> -Brent

Other Threads

1. Not sure if this can be done

2. Not sure if it's a bug?

3. sure its been done b4

4. I'm sure you've heard this before

5. I'm sure you've heard this before

6. Elementary (I'm sure) BatchMove Problems

7. Outlook + Internet Simple Question I'm sure?

8. I'm sure someone knows how

9. I'm sure something is wrong here.

10. I'm sure this is dumb ...