| Author |
Message |
kevin83177
Joined: 18 Apr 2007
Posts: 10
Country: United States |
|
 INSERT INTO INTO Issue |
 |
When you type INSERT INTO and select a table name it adds another INTO.
INSERT INTO INTO ClientAccess
(
IdClientAccess,
IdClient,
IdEmployee,
CdType
)
VALUES
(
/* IdClientAccess */,
/* IdClient */,
/* IdEmployee */,
/* CdType */
)
|
|
| Tue Feb 05, 2008 8:44 am |
  |
 |
kevin83177
Joined: 18 Apr 2007
Posts: 10
Country: United States |
|
| |
|
It also does this creating DELETE statements.
|
|
| Tue Feb 05, 2008 8:53 am |
|
|
kevin83177
Joined: 18 Apr 2007
Posts: 10
Country: United States |
|
| |
|
The DELETE puts in FROM FROM
|
|
| Tue Feb 05, 2008 8:53 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
Which version of SQL Assistant are you running? In which target editor?
|
|
| Tue Feb 05, 2008 10:52 am |
|
|
kevin83177
Joined: 18 Apr 2007
Posts: 10
Country: United States |
|
| |
|
Version 3.1.12 SQL Server target.
I found that if you select a table from the drop down list after you type the words INSERT or DELETE it will insert the single FROM. However if you type INSERT INTO and then select a table, it duplicates the INTO word. Same goes for the DELETE. If you type DELETE FROM and select a table it will duplicate the FROM word.
|
|
| Tue Feb 05, 2008 11:26 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
Thanks a lot for the feedback. We will get this bug fixed before public release of v3.1.
|
|
| Tue Feb 05, 2008 11:38 am |
|
|
|
