Send Matrix to SQL ??

[drPavlovic]

Does anybody has idea for following :

I should send matrix to SQL from Microsoft Access

For example :

One Person has more Certificates , and table PersonCertificates looks like this:

PersonID ----- EducationInstitutionID ------ Certificate

1 ---------- 1---------------------- Elektrotechnical technician
1 ----------- 6 -------------------- Engineer
1 ----------- 8 -------------------- Master of Science.

I'm thinking to send it as Collection (or 2 dimension Area) , but how to accept it in MS SQL stored procedure ??? (to define filed of type "table" in stored procedure? )

10 x thanks in advance

 

[KeithG]

Can you explain a little more? Are you using Access as a FE for your SQL Server?

 

[drPavlovic]

Access + SQL

Keith G: yes, I use this combination : MS Access 2003 as Front End + SQL Server 2000 as Back End.

I'm trying to make OOP application in Access, and .. it works up to now .. not all the features you can see in .NET, but, classes, inheritance, works fine ..

So, now i do have : Form with field to be filled , and it should be (as I wrote)
in subform , Matrix like : 1, 1, Technician
1, 7, Engineer
1, 9, Master of Science

on the other side, Back-end, should be stored procedure, to accept this matrix, and to insert into table PersonEducation.

I'm sending data to SQL , by using ADO, Command, and Parameters collection.

So, I'm wondering , can I use variable "AdArray" data type, to store this matrix inside ?

Pat Hartman: of course there are a lot of reasons not to use 'bound forms'. It 's a milion times easier, and I'd rather use it, but .. for Client - Server, application, where bussines logic is stored on SQL server, you cannot, just bind form with table and enter data.

Thank you guys