Assign Table-Type input paramater in SQL Server with Delphi 2010

Question

0.00/5 (No votes)

See more:

I need to copy records from Paradox-7 tables to SQL Server 2008.

I have created a stored procedure in SQL Server 2008 with a table-type input parameter.

Using Delphi 2010, how can I send a Paradox DB table's records to this stored procedure?

The tables already exist in SQL Server.

I tried this, but it gives an error regarding the paramater type:

Delphi

VAImpTable.Open;   // this is a BDE TTable component
// spBatchInsert is a dbExpress TSQLStoredProc component
spBatchInsert.ParamByName('@input_table').AsDataSet := VAImpTable;
try
  spBatchInsert.ExecProc;
except on e: Exception do
  ShowMessage(e.Message);
end;
VAImpTable.Close;

Posted 12-Jan-12 0:15am

TerenceZ

Updated 12-Jan-12 0:17am

RaisKazi

v2

Add a Solution

Comments

MahendranGK 12-Jun-14 5:58am

Can anyone help me on this. This solution doesnt work. THanks in advance

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nortee · Answer 1 · 2012-02-29T03:03:00

Hi,

I know this is probably a bit too late, but since there haven't been any responses, I might as well give this a shot. I may be wrong regarding this, but shouldn't that code looks something like:

Delphi

VAImpTable.Open;
VAImpTable.First;
VAImpTable.FetchAll; // Make sure we have ALL the data for the migrate
VAImpTable.First; // Just to make sure that we are back at the first record
spBatchInsert.ParamByName('@input_table').DataType := ftDataSet;
spBatchInsert.ParamByName('@input_table').Direction := pdInput;
spBatchInsert.ParamByName('@input_table').Value := VAImpTable;
try
  spBatchInsert.ExecProc;
except on e: Exception do
  ShowMessage(e.Message);
end;
VAImpTable.Close;

I know the "AsDataSet" is short-hand, but personally I prefer setting certain properties, especially things like data source parameter inputs, explicitly.

Having said that though, I had issues many moons ago converting the data source of an application from one provider to another. I just ended up writing a generic class that would physically move the data from the one to the other.

At that stage, it proved to be much more reliable, because I could then write descendant classes which would then be specific to certain types of (provider) database types as some (field) definitions didn't port properly between the two.

Hope that helps,
Glen

Assign Table-Type input paramater in SQL Server with Delphi 2010

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us