mvitlov / vscode-db-explorer-firebird

Explore and run queries against your Firebird® databases without leaving VS Code.
MIT License
21 stars 11 forks source link

Not showing table rows in Firebird Query Results #10

Open fusakla99 opened 4 years ago

fusakla99 commented 4 years ago

I have successfully connected to firebird DB. Have changed default table count in tree view from 10 to 100. When I choose for any table by right clicking on table name "select all records" it show in results pane some weird icon and not table as shown in attached printscreen error

fernandovb commented 4 years ago

I have the same problem. Selecting "select all records" or "show table info" shows nothing on the screen.

Wirtu commented 4 years ago

same problem

luizfss commented 4 years ago

same problem.

jian-kowalski commented 4 years ago

same problem.

Przemyslaw-Witczak commented 4 years ago

I have the same problem. Selecting "select all records" or "show table info" shows nothing on the screen.

patrix commented 4 years ago

same problem. 😕

code-moses commented 4 years ago

Same problem here. The console displays an error from the WebView, saying "Cannot load resource outside of protocol root". But WebViews shouldn't be able to read files on one's computer by design as far as I understand from my research, so why make one that tries to?

FomenkoOleksandr commented 4 years ago

same problem.

mvitlov commented 4 years ago

Not sure, about the problem, because I'm not able to reproduce it myself. My guess is that it's related with system-level privileges maybe?

The extension is only reading html/css/js files inside extension bundle that are used to generate table results (it's easier than generate results on-the-fly).

fernandovb commented 4 years ago

mvitlov, thanks for answering. I do not believe that privilege issue, because I enter as SYSDBA. Another point is that I successfully deleted a table. I tried to create a new table, but found no option to write or execute the code. Are there any configuration suggestions that can be applied to VS CODE?

MrBenWang commented 4 years ago

same problem.

I see the log, maybe the SQL is error, in my application the right like SELECT * FROM "configuration"; If the table name without quotation mark, show the same ERROR;

[下午10:15:14][vscode-db-explorer-firebird][INFO] Custom Query: Select All Records [下午10:15:14][vscode-db-explorer-firebird][DEBUG] Run Query start... [下午10:15:14][vscode-db-explorer-firebird][INFO] Executing Firebird query... [下午10:15:14][vscode-db-explorer-firebird][ERROR] Error: Dynamic SQL Error, SQL error code = -204, Table unknown, CRASHRESCUE_FLASHTOOL, At line 1, column 15

voyceik commented 4 years ago

Same problem.

In the Output View shows:

[17:00:06][vscode-db-explorer-firebird][INFO] Executing Firebird query... [17:00:06][vscode-db-explorer-firebird][INFO] Finished Firebird query, displaying results...

But same "broken icon" in Firebird Query Results. Maybe if there was an option to show in plain text it can resolved.

mikemcs121 commented 4 years ago

Same Issue

Sample

suganda commented 4 years ago

same problem

yusufgroenewald commented 4 years ago

Same issue. I gave up and reverted to using a commercial tool called Firebird Maestro - quite comprehensive with a 30-day free trial including all features.

rodrigocnovos commented 3 years ago

Same problem!

JamesYangLim commented 3 years ago

same problem, any update for this issue?

MisterNicoLarson commented 2 years ago

Any update about this problem ?

I have try all possible things like new provider, install/uninstall, change config file, the best I had is a vsc crash.

jan-vaclavik commented 1 year ago

Same problem