Your SELECT 10 FROM …. Is actually looking for a column named 10 from the
sys_forms3 table.
I don't believe so. I use this syntax all the time for table-to-table INSERTs.
If I CREATE TEMP TABLE ttblTestData in the R:Base database and then issue the
command against that table then it works fine. INSERT INTO SVRTestData
(IntColumn) SELECT SYS_ODBC_TYPE FROM SYS_COLUMNS WHERE LIMIT = 1
Same error.
--Larry <!--#yiv5249033414 _filtered #yiv5249033414
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5249033414
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv5249033414
{font-family:Garamond;panose-1:2 2 4 4 3 3 1 1 8 3;} _filtered #yiv5249033414
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv5249033414
#yiv5249033414 p.yiv5249033414MsoNormal, #yiv5249033414
li.yiv5249033414MsoNormal, #yiv5249033414 div.yiv5249033414MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";color:black;}#yiv5249033414 a:link, #yiv5249033414
span.yiv5249033414MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5249033414 a:visited, #yiv5249033414
span.yiv5249033414MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5249033414 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier
New";color:black;}#yiv5249033414 span.yiv5249033414HTMLPreformattedChar
{font-family:"Consolas", "serif";color:black;}#yiv5249033414
span.yiv5249033414EmailStyle19 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv5249033414 .yiv5249033414MsoChpDefault
{font-size:10.0pt;} _filtered #yiv5249033414 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv5249033414 div.yiv5249033414WordSection1 {}-->
