Pb when interogate DB

[17mounir]

hi,
I'm novice in WinRunner, I'm trying to make a small database test, I'm connected to the DB, I can create table, add lines, but I can't interogate it with :
- db_get_row ( )
- db_get_field_value ( )

db_connect(DSN,"DSN="&DSN&";UID="&UID&";PWD="&PWD) ->ok
db_execute_query(DSN,sql,Nbr_Enreg) -> ok
compare_text("23/06/1983",db_get_field_value(DSN,"#0","Date_N")) -> KOOO

I don't know exactly what's the 2nd argument of db_connect() baut I think that I'm correctly connected if I can create tables

 

[17mounir]

I found my mistake, it's too stupid :
- I forgot de SELECT querry before
- the name of field must be in capital letter

 

[DPlank]

Happens to us all, it's all a learning experience...

Cheers,
Dave

Probably the only Test Analyst Manager on Tek-Tips...therefore whatever it was that went wrong, I'm to blame...

animadverto vos in Abyssus!

Take a look at Forum1393!