Re: Adding relationships between tables using ADODB and ADOX
From: Jerommeke (jeroenvv_at_home.nl)
Date: 03/25/05
- Next message: Dave: "How 2 get auto id of new record"
- Previous message: Chad: "Clone Recordset to new Recordset with Append.Fields"
- In reply to: Jerommeke: "Adding relationships between tables using ADODB and ADOX"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Mar 2005 19:24:37 +0100
"Jerommeke" <jeroenvv@home.nl> wrote in message
news:d1s9mb$qm4$1@news5.zwoll1.ov.home.nl...
> Hello
>
> I am working on a C# databaseproject using ADO .NET
> Today I discovered that ADO .NET can not create permanent table columns
> and/or table relations. I need to do that because when I release a new
> version of my software, old databases need to be upgraded.
>
> I solved the problem for the columns by using an SQL statement, and later
> I realized another solution by using ADOX en ADODB through COM
> interoperability.
>
> However, I don't seem to find a useful example that shows me how to
> programatically add a permanent relationship in a database using ADOX
> and/or ADODB
>
> can anyone help me with a useful example??
>
> regards
>
> Jeroen van Vlierden
>
I managed to do it, with some effort
- Next message: Dave: "How 2 get auto id of new record"
- Previous message: Chad: "Clone Recordset to new Recordset with Append.Fields"
- In reply to: Jerommeke: "Adding relationships between tables using ADODB and ADOX"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
