Target table not found

[olajiredominic]

Hi👋,

Tried using the plugin but kept getting target table not found error

[romanstr]

At times, I encounter the same error and need to reload ADS to resolve it.

[olajiredominic]

At times, I encounter the same error and need to reload ADS to resolve it.

It worked.

Noticed N is appended to the result of the first column

[romanstr]

That is correct. N is a special syntax for nvarchar strings.

However, the bug causing the error message "table not found" can be quite disheartening at times :)

[LycanII]

Hey Guys ,
Sorry about this bug, I have actually been trying fix it but kinda delayed in getting to it.
Thanks @romanstr for helping @olajiredominic out .I really appreciate it.

I will try to fix it hopefully this weekend .
🙂

[LycanII]

Reopened to track fix for it :)

[cgaspard]

I think I have a fix in this pull requst:

#16

I am unable to test it since I don't have a full environment setup, but I confirmed it is able to parse the sql properly in this fiddle.

Also note, that this detects subquery and join tables as well, but the first item in the returned array should be the primary table I believe in most cases.

https://jsfiddle.net/cgaspard/pqymw7de/

[atbez-miview]

I see this is still open. I suddenly started receiving this error today. I have used the same version of LS in the last month and I hadnt updated my ADS, so I dont know what changed. reloading ADS does not seem to help. After receiving the error, I did at that point update ADS. No resolution.

[TheRancid]

I see this is still open. I suddenly started receiving this error today. I have used the same version of LS in the last month and I hadnt updated my ADS, so I dont know what changed. reloading ADS does not seem to help. After receiving the error, I did at that point update ADS. No resolution.

Same here, but I found out that the error is raised only if I explicitly list the columns I want to be exported in the SELECT statement. Instead, if I use the * selector, I can successfully export the results, both to clipboard and new tab.

[TheRancid]

I see this is still open. I suddenly started receiving this error today. I have used the same version of LS in the last month and I hadnt updated my ADS, so I dont know what changed. reloading ADS does not seem to help. After receiving the error, I did at that point update ADS. No resolution.

Same here, but I found out that the error is raised only if I explicitly list the columns I want to be exported in the SELECT statement. Instead, if I use the * selector, I can successfully export the results, both to clipboard and new tab.

Actually, that's not the general case, since I found tables which results cannot be exported even with * selector: it must be some condition on the table or data itself that causes the error to be raised.

[RGalli]

Same error here