Re: [gnome-db] INSERT statement with binary data

[Daniel Espinosa <esodan gmail com>]

Where in documentation exist a table for quick reference data type conversion? when using parameters I need to pass a string to specify the data type but but string I need to use for correct parameter's data type.

I think in GdaSqlParser must be a reference to that table in order to use the correct strings. I filed a bug #568731 for this

2009/1/22 Vivien Malerba <vmalerba gmail com>

2009/1/22 Johannes Schmid <jhs jsschmid de>

Hi!

OK, I finally got this working but I have a question on the data types.
If I pass something like

(##contact_id::int, ##first_name::string, ...)"

but contact_id has a value type GdaNumeric that libgda complains that
the data types do not match. Same when I passt first_name::varchar.
Shouldn't libgda handle such conversions itself?

Yes, right now Libgda is very conservative about data types matching, and automatic conversions should be implemented when possible. Anyway, this is post V4.
 

Btw, I still think that those gda-easy methods are general useful also
in the C++ bindings.

Yes, I've added this to my TODO list.
 
Cheers,

Vivien

_______________________________________________
gnome-db-list mailing list
gnome-db-list gnome org
http://mail.gnome.org/mailman/listinfo/gnome-db-list

-- 
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (en trámite, pero para los cuates: LIBRE)