get stock from substraction of sales from purchases for all items
I am inexperienced with firebird or SQL, nevertheless I need to export fields that meet certain criteria from a Firebird database. The entire database weights 2 GB, I dont think I can easily share it with someone. The problem lies with the quatity of products. Aparently it is not embeded in a table´s colum but is fetched through a procedure that is called through an item id. This procedure I will share if someone requests it.
My thoughts are, if the quantity can be called through a procedure, then the call can be modified to export only available items to a table. whole positive non-zero values can be exported to their own table. Thus reducing the ammount of items to only those in physical inventory.
the procedure is basically substracting sales from purchases.
I would appreciate any replies that may shine a light to my thoughts, and will promptly reply with the above mentioned procedure if anyone is willing to take a shot at this.
Any other suggestions or comments are welcomed.
Troubles with firebird 1.5 connection with c# and FirebirdSql.Data.FirebirdClient.dll
Link Greenleaf a través de googlegroups.com 14:14 (hace 8 horas) para firebird-net-provider Hi, Im trying connecting to a Firebird Database 1.5. with FirebirdSql.Data.FirebirdClient.dll in c# VS20150 votes0 answersLINK GREENLEAF4 months ago
Firebird Connection Problem
Hello. My name is Frans. And i have some issue about the connection Firebird Server. In my server, i have installed Firebird Server with command line (Windows) and it takes successfully to run the apps.0 votes0 answersFrans Wiradinataon Jun 14, 2017
gds32.dll load issue using MS Access ADODB connection
Hi, I am having a problem connecting MS Access and firebird. Access and Firebird are all 32-bit, running on Windows 7 64 bit.0 votes0 answersMark Walterson May 15, 2015
Connect to firebird database using Visual Studio
USING VS2013 Trying to export BLOB data to individual files deom Firebird database. I Dont know how to include a reference to FirebirdSql.Data.FirebirdClient.dll0 votes1 answerjulio sitgeson Apr 27, 2015
Cadena de conexion Con BD firebird 2.5 desde Visual Basic en Visual Studio 2010
Hola estoy intentando conectarme con una BD Firebird y no hay manera de hacerlo, la cadena que utilizo es: "ServerType=0;User=JOSEVI;Password=josevi;Size=4096;Dialect=3;Pooling=FALSE;database=localho0 votes0 answersJosé Vicente Zahoneroon Oct 14, 2011
Como pasar los datos a un datagrid (how to pass data to a datagrid)
ya pude hacer la conneccion de la bd a visual basic 6.0 pero no se como conectar esos datos a un datagrid alguien me podria ayudar (Now I can make out connection to the db to Visual Basic 6.0 but n0 votes1 answerYovani Felixon May 07, 2010
- Load more posts