[Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-25 Thread Amanda Kabak
I'm trying to get the default values for the columns in my database. I can get column names and types through the connection.GetSchema("Columns") method. The schema of the table returns includes "COLUMN_DEFAULT", but the value it returns is always a zero-length string. Any ideas how to get this

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-26 Thread Carlos Guzmán Álvarez
Hello: I'm trying to get the default values for the columns in my database. I can get column names and types through the connection.GetSchema("Columns") method. The schema of the table returns includes "COLUMN_DEFAULT", but the value it returns is always a zero-length string. Any ideas how to

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-27 Thread Amanda Kabak
Carlos Guzmán Álvarez wrote: Hello: I'm trying to get the default values for the columns in my database. I can get column names and types through the connection.GetSchema("Columns") method. The schema of the table returns includes "COLUMN_DEFAULT", but the value it returns is always a zero-

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-29 Thread Carlos Guzmán Álvarez
Hello: Thanks. I just wanted to mention that it is with version 1.7.0.1 of the provider. Can you send a sample of the table that is giving you the problem ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.net

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-29 Thread Amanda Kabak
Carlos Guzmán Álvarez wrote: Hello: Thanks. I just wanted to mention that it is with version 1.7.0.1 of the provider. Can you send a sample of the table that is giving you the problem ?? The script to create the table is attached, and below is an insert statement with the current data. Tha

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-30 Thread Carlos Guzmán Álvarez
Hello: The script to create the table is attached, and below is an insert statement with the current data. Thanks for your help! In a first test it looks as working fine for me. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-30 Thread Amanda Kabak
Carlos Guzmán Álvarez wrote: Hello: The script to create the table is attached, and below is an insert statement with the current data. Thanks for your help! In a first test it looks as working fine for me. Can you send along your code and connection string so I can try to debug what's go

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-31 Thread Carlos Guzmán Álvarez
Hello: Can you send along your code and connection string so I can try to debug what's going on here? I have done nothing special, just open the connection and call GetSchema("Columns", new string[] { null, null, "table_name" }) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.c

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-31 Thread Amanda Kabak
Carlos Guzmán Álvarez wrote: Hello: Can you send along your code and connection string so I can try to debug what's going on here? I have done nothing special, just open the connection and call GetSchema("Columns", new string[] { null, null, "table_name" }) Two questions: Any idea how I

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-31 Thread Carlos Guzmán Álvarez
Hello: Two questions: Any idea how I should go about debugging this? Is there a connection string setting I should be looking at? I'm still getting empty strings for default values (xml version of my dataset is attached). And, once I get it working, is there a function to submit changes to the

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-31 Thread Amanda Kabak
Yep, this gets values: "DEFAULT 4" for example. Carlos Guzmán Álvarez wrote: Hello: Two questions: Any idea how I should go about debugging this? Is there a connection string setting I should be looking at? I'm still getting empty strings for default values (xml version of my dataset is att

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-01-31 Thread Carlos Guzmán Álvarez
Hello: Yep, this gets values: "DEFAULT 4" for example. I have done a test using 1.7y as well, and looks as working fine for me too. If you can get a copy of the sources from the cvs, do the build using debug information and try to debug the command that is being executed ( in DbSchema.cs )

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-01 Thread Amanda Kabak
What's the address of the repository? I've never had to get the sources before ... Carlos Guzmán Álvarez wrote: Hello: Yep, this gets values: "DEFAULT 4" for example. I have done a test using 1.7y as well, and looks as working fine for me too. If you can get a copy of the sources from

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-01 Thread Amanda Kabak
This is very strange. With the debug version of the latest 1.7 release candidate (sources on the firebird site), it works correctly. I will continue to use this version for development purposes and then figure out how to switch over to a release version at some point moving forward, I guess. An

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-03 Thread Carlos Guzmán Álvarez
Hello: This is very strange. With the debug version of the latest 1.7 release candidate (sources on the firebird site), it works correctly. I will continue to use this version for development purposes and then figure out how to switch over to a release version at some point moving forward, I g

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-03 Thread Amanda Kabak
Carlos Guzmán Álvarez wrote: Hello: This is very strange. With the debug version of the latest 1.7 release candidate (sources on the firebird site), it works correctly. I will continue to use this version for development purposes and then figure out how to switch over to a release version at

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-07 Thread Amanda Kabak
Did you mean to modify the default value of a column ?? Hey, sorry to be a pest about this, but is there a way to modify the default value of a column using the data table returned from the connection.GetSchema function or do I have to write ddl for it to happen. Is there any sample code aro

Re: [Firebird-net-provider] connection.GetSchema("Columns") doesn't return default

2006-02-07 Thread Carlos Guzmán Álvarez
Hello: Hey, sorry to be a pest about this, but is there a way to modify the default value of a column using the data table returned from the connection.GetSchema function or do I have to write ddl for it to happen. Is there any sample code around? Any help would be hugely appreciated ... You