What’s the best network connection?
Hello! I have and old client-server application written in Visual Basic 6. My database is MySQL 4.0. It has 10 concurrent clients under the same LAN. I need to make a new android application to run on tablets. The new app must connect via Mobile Internet to my old client-server application (or another layer to...
| March 11, 2014 9:33 AM
How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.
| January 23, 2014 8:38 AM
, MySQL Stored Procedures
, SQL stored procedures
, Stored Procedures
PowerBuilder Printing Problem
hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don’t think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.
| December 18, 2013 5:15 AM
Database Management Systems
, Microsoft Windows
, PC/Windows Connectivity
, Tech support
AS/400: ODBC call continues to hang
My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC driver and the iSeries...
| December 14, 2013 9:32 PM
Open ended SQL queries
Hi all, I have a requirement to trace the open ended SQL queries running in Oracle Can anyone please help me with a solution. Also please provide me some links where I can find info about Open ended SQL queries. Thanks in advance
| November 22, 2013 12:31 PM
, SQL queries