Search

You are currently browsing the MS SQL Server category

PowerBuilder ‘Gotcha’ – Datawindow retrieval arguments

Posted on July 16, 2010 at 8:22 pm in

So I’m working on a scheduling process and I have a datawindow object which takes a number of arguments.I have them set up as al_pro_id (long), adt_end (datetime), adt_start (datetime), al_resource_id[] (long array), and al_dept_id (long). To save from maintaining two separate objects, I used this object for a datawindow as well as for datastores…

PowerBuilder ‘Gotcha’ – Datawindow retrieval arguments - the full story »

PowerBuilder & MS SQLServer datetime methods

Posted on July 6, 2010 at 8:37 pm in

If you have scheduling functionality in your application sooner or later you are faced with spanning dates. By this I mean starting something on one day and ending it on another. Powerbuilder is not very good at this, especially if you have something which starts before midnight and ends after midnight. SQL Server provides good…

PowerBuilder & MS SQLServer datetime methods - the full story »

Msg 7391 in SQL Server

Posted on September 30, 2009 at 10:42 am in

So I’m setting up a stored procedure in SQL Server 2000 to access some data on an Oracle database. The DBAs have set up the linked server in SQL Server to the Oracle source with the name ‘DTEST’. I’m going to need to use the OPENQUERY method since I need the statement to execute in…

Msg 7391 in SQL Server - the full story »

Top