I am creating an application with the Advantage database server. I want to insert a data using the stored procedure
I tried an input parameter, this is the stored procedure:
CREATE PROCEDURE SP_FolioComp
(
@NumFolio CHAR ( 11 )
)
BEG...
I have a table with the following structure:
ID MONTH
21714 JAN
76101 JAN
175187 FEB
243575 APR
299116 JUN
304742 JUN
I need to generate a string of 14 characters for each record similar to 'ABC00...
Hi, I'm working with ASP.Net / SqlDataReader / C # and razor I have the sig. complication ...
I'm trying to show a table using AJAX but I'm not sure I'm doing it right, so I understand I have to make a method for my query to be stored in a list...
I have a database about movies and I want to show the name of the genres a movie is assigned to.
Diagram (example values in red):
- EDITED -
This error comes out:
The method getString (String) is undefined for the type String...
I have a table with several fields and my goal is to bring only the id that appear only once and whose fields 3 and 4 are not null (any of them)
The query you make is the following
SELECT id
FROM tabla
WHERE campo3 IS N...
I have the following code which gives me the error shown, it seems to me that I am misplacing some quotes.
Declare '@Cuenta Varchar(25),@Fecha Varchar(10),@Moneda Varchar(3),@User Varchar(20)'
Declare '@NomTabla Varchar(60)'
SET @User...
The following scenario is presented to me, I have in my HTML a <textarea> in which the user will enter a query, as if it were the command line, example, I can enter:
SELECT * FROM users;
SELECT * FROM countries;...
I would like to know if there is any way to rename the keys of an associative array that is given by PDOStatement :: fetch.
The sentence that I prepare and execute in SQL does not come to the case in itself (although if they require it, I can ad...
I am developing an application in C # to recover data from a database. The case is: when I try to execute the statement I get this error:
"System.InvalidOperationException: Fill: The SelectCommand.Connection property has not been initializ...
After making the following query:
SELECT CP.code
FROM cart_products AS CP
INNER JOIN products AS P
ON P.code = CP.code
WHERE CP.cartID = 22207
AND (P.stock - CP.quantity) > 0
I got the following error:
# 1690 - BIGI...