Flowise icon indicating copy to clipboard operation
Flowise copied to clipboard

[BUG]how dose SQLDatabase Chain go when I

Open littleKanghui opened this issue 2 years ago • 5 comments

when I add a include table for sqlDatabase Chain ,it thow [the do not contains table margin_trading] ,but my database exactily contains this table image image image

how does it happend? please help me!

littleKanghui avatar Dec 21 '23 11:12 littleKanghui

@littleKanghui we released another template - SQL Prompt which allow a more robust way to use your prompt, connect to your databases using custom JS function: image

in the meantime, we'll take a look at the Include Table issue

HenryHengZJ avatar Jan 04 '24 18:01 HenryHengZJ

@HenryHengZJ this is for MySQL? How to modify this template as I have SQL Server MSSQL

scheung38 avatar Feb 03 '24 22:02 scheung38

Keen to know why for example a ChatOpenAI node is replicated x3 times here when a single node instance of ChatOpenAI node can fan out to x3 connections?

scheung38 avatar Feb 03 '24 22:02 scheung38

Keen to know why for example a ChatOpenAI node is replicated x3 times here when a single node instance of ChatOpenAI node can fan out to x3 connections?

Flowise traverse the graph from left to right, hence 3 nodes are needed instead of just 1, otherwise it will causes the graph into infinite loop

HenryHengZJ avatar Mar 30 '24 10:03 HenryHengZJ

@HenryHengZJ this is for MySQL? How to modify this template as I have SQL Server MSSQL

this is for SingleStore SQL, but its a piece of JS code that is modifiable

HenryHengZJ avatar Mar 30 '24 10:03 HenryHengZJ