Search results for query: *

Does anyone have step by step directions, or point me to a place that does, on how to create the datawindow object that will be loaded with an XML file?

Recently our database server was upgraded and although PowerBuilder runs fine, when I click design, data source for a datawindow I get the following error. "Table "csd_currentenrollmentcount" has no columns; possible invalid table format. Please check to see if the active DB Profile is correct...

Does anyone have any ideas as to why the cancel button does not cancel printing a datawindow? Its a simple dw_1.Print(TRUE). When clicking the Cancel Button it still sends the datawindow to the printer for printing. I've done a lot of searching but cannot figure this one out. Thank in advance...

I am trying to take an executable that was created in PB12.6 classic and have users execute it from that server. The project creates the executable with no errors. When I copy the executable to the server and try to run, I get an error stating the PBVM126.dll is missing. In earlier versions of...

Does PFC come as part of PB12.6? If not, how can I get this? Thank you for your help Dominick

Recently our database was upgraded from SQL Server 2008 to 2014. Powerbuilder 12.6 runs on this platform however datawindow objects created in 2008 produce an error when clicking on Data Source. Error states "Table 'my table' has no columns; possible invalid table format. Please check to see if...

I have a external datawindow object that I set columns and rows. What I need to do is have all the rows display at the same time, at run time,rather than having to tab down each row. I see all the values when I run the program (by clicking the page down key), however, only one row can be seen...

I have two datawindows dw_1 and dw_2 dw_1 contains all a teachers students throughout many years, designated by the column named "year" and the value '14-15', '15-16' etc.. dw_2 contains only the column "year" with the same format '14-15','15-16'. Passing of the year works using...

I am trying to create a temporary table that is loaded each timea user logs into the application. I am building the table dynamically and my error checks are coming out showing no errors. However, when I try to build the SQL statement to load the contents of the temp table, I do not see any...

Hello, I am new to PowerBuilder 12.6. Years ago I programmed if PB6.5 but this is so different. Why would a datawindow object not get the latest changes that were made to a query? the steps I am taking is I open the datawindow object, click on Design > Data Source. The query displays with the...

Hello everyone, I am hoping you can help with this. Below is a table in our database called PaymentTransaction. One of the columns is a varchar(2000) that contains a string that contains data from a payment transaction from an outside source. This table records a parents payment to their...

I would like to use Excel to connect to my MS SQL Server database to run a query that is scripted inside the Excel workbook. Is there a way that the username and password be contained in the workbook so the user does not have the connection box show? It is a generic username and password that is...

I am trying to delete the first 3 records in a table but am at a loss as how to do it. Table looks like this... create table #classCuts ( lastname varchar(50), firstname varchar(50), studentnumber varchar(15), coursenumber varchar(13), sectionnumber int, coursename...

I am trying to have a column in a table contain a % of students that recieved a certain grade for a particular standard. This is a sample of the table I am querying.. Table Name #elementary_score_final_aggregate school varchar(8), gradeLevel varchar(8)...

Hello All, I need to create a template that has many values a user can select. I would like to incorporate the use of "check box's" but I am not sure if Crystal supports this. By selecting one or more of these check boxes, I would like to update a SQL SERVER table with the values selected. Is...

Hi. I was wondering if there is a way to "refresh" a stored procedure in Crystal. It seems that when I change code in a stored procedure, Crystal does not execute the new procedure. Is there a way to refresh to the new version of the code or do I have to relink and then create a new report...