Hi guys,
I'm using Dataset in my project. In design time I configure TableAdapter in
the Dataset and set to the adapter as an Insert query following sql:
INSERT INTO UserInterface.ViewFields
(createdBy, createdOn, modifiedBy, modifiedOn, viewId,
fieldId, logicalFieldName)
SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID,
fld.id, clmn.name
FROM UserInterface.Fields AS fld INNER JOIN
DBMetaData.Columns AS clmn ON fld.columnId = clmn.id
WHERE (clmn.tableId = @tableID)
The problem is that the method automaticaly generated by VS for this only
sql (with others I don't have such a problem) has no parameters!!! I was
more confused, when by click on "Query Builder..." -> "Execute Query" in
"TableAdapter Query Configuration Wizard" VS asked me to enter these
params!!!
Does anybody know about the bug, and know how can I resolve it?
Thanks a lot
Aleksey
Nicholas Paldino [.NET/C# MVP] - 18 Jan 2008 18:33 GMT
Aleskey,
I think part of the reason is the name of the table (i.e.
UserInterface.ViewFields).
Try changing "UserInterface.ViewFields" to "[UserInterface.ViewFields]".

Signature
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com
> Hi guys,
> I'm using Dataset in my project. In design time I configure TableAdapter
[quoted text clipped - 18 lines]
> Thanks a lot
> Aleksey
Aleksey Timonin - 18 Jan 2008 18:39 GMT
I have tried it. It doesn't make defference. I still have the same problem.
And as I have said below QueryBuilder is see these params!
Any idea?
> Aleskey,
>
[quoted text clipped - 26 lines]
>> Thanks a lot
>> Aleksey