Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not showing table rows in Firebird Query Results #10

Open
fusakla99 opened this issue Sep 5, 2019 · 19 comments · May be fixed by #21
Open

Not showing table rows in Firebird Query Results #10

fusakla99 opened this issue Sep 5, 2019 · 19 comments · May be fixed by #21

Comments

@fusakla99
Copy link

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
Copy link

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

@Wirtu
Copy link

Wirtu commented Sep 6, 2019

same problem

@luizfss
Copy link

luizfss commented Sep 10, 2019

same problem.

1 similar comment
@jian-kowalski
Copy link

same problem.

@Przemyslaw-Witczak
Copy link

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

@patrix
Copy link

patrix commented Nov 20, 2019

same problem.
😕

@code-moses
Copy link

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
Copy link

same problem.

@mvitlov
Copy link
Owner

mvitlov commented Dec 17, 2019

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
Copy link

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
Copy link

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
Copy link

voyceik commented Mar 21, 2020

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
Copy link

Same Issue

Sample

@suganda
Copy link

suganda commented May 13, 2020

same problem

@yusufgroenewald
Copy link

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
Copy link

Same problem!

@JamesYangLim
Copy link

same problem, any update for this issue?

@MisterNicoLarson
Copy link

MisterNicoLarson commented Nov 5, 2021

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
Copy link

Same problem

@ila-embsys ila-embsys linked a pull request Aug 4, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.