Search results for query: *

Rottdpogs, Can you call the SQL Server stored procedure via MS Query Analyzer passing the exact same data parameters to the query? MS SQL Server may be encountering a data conversion problem which has nothing to do with PB. Good Luck.

We are running PB 9.0.1 Enterprise and MS SQL Server 2000 (STD Edition). This app is not n-tier - it is straight client/server. Currently we're using the old MS SQL Server 6.x native mode driver (PBMSS90.dll) for connectivity to the database. This currently works fine, however, when we...

If the query is not too complex you could use Excel directly using 'Data' -> 'Get External Data' if Microsoft Query is installed on your PC. You would need to set up a connection to the database (ODBC) and then write/build your query and save it via Microsoft Query. You then return the data to...

I would like to be able to either send a message to another open window (or just trigger the event in the receiving window) from the current open window and I'm having a little difficulty determining how to accomplish this. The situation is that after data is saved (in the pfc_postupdate event...

I was wondering if anyone would respond with that answer :) It is a little more involved than that since I was having to do reversing entries based on whether the debit/credit was negative or not. I did not include it in my example in trying to keep the example simple, but I digress. Turned...

This is going to sound weird. Anyone have any idea why summing a computed field in a group and then summing this summed computed field in the summary band in a datawindow results in a incorrect total? Any workarounds? It's behaving the same way in PB 7 and PB 9. Is it a problem with how my...

First, you'll need to decide what type of barcode scanner you want to use and what type of barcode - UPC, Code 39, codabar, etc. (codabar is pretty much obsolete). For normal PC applications, a barcode scanner using a keyboard interface usually works best - these type plug in-line with your...

Your statement: SELECT * FROM @TABLE_NAME is not valid You can use the @TABLE_NAME variable in other SQL statemtents, however, it is not a table that can be queried. You could include it in a SELECT statement such as: SELECT @TABLE_NAME, * FROM CUSTOMERS WHERE CUSTOMER_REF = @CLIENT...

Variables used in FROM clause is OK, I use them frequently with the same syntax noted in the examples above without a problem. Are you using MS Query Analyzer or some other tool?

SELECT @TABLE_NAME = TABLE_NAME FROM CUSTOMERS WHERE CUSTOMER_REF = @CLIENT

Which Build of PB 9 are you running? I'm running PB 9.0.1 Build 7066 and can save Datawindow data as XML without problems. I'm still having problems trying to save as pdf, however. Back to your problem - you may want to look at Sybase's website to download an EBF or to scan through the fixes...

Hello all, I have been trying to figure out what is required to save a datawindow to a .pdf file w/PB 9.0.1 and have not been able to do so successfully. I read in the PB online documention that GNU Ghostscript and some printer drivers need to be installed in the path of the application, but...

Posted too soon, found this: Change Request#: 325824 Priority: 0 Product Name: PB Enterprise - 9.0.1 OS: Microsoft Windows 2000 Product Component: Edit Mask Fixed in Version #: 9.0.1_7066 Description: Regression: The editmask date dd.mm.yyyy does not allow values starting with a 3 to be...

Found this today on Sybase Support for newest PB 9.0.1 build (7066): Change Request#: 339166 Priority: 0 Product Name: PB Enterprise - 9.0.1 OS: Microsoft Windows 2003 Product Component: DW Edit Mask Fixed in Version #: 901_7066 Description: Datawindow EditMask does not let one enter Feb...

Thanks, but yes, this setting has been selected. I've run out of ideas and may have to contact Sybase. I haven't contacted them yet because we only pay for software maintenance upgrades and do not pay maintenance for tech support.

mexicomeat - exported both 7.0.3 and 9.0.1 versions to a .srd files and used the Compare Differences tool (PVCS Merge Tool) to examine the differences and there are none. Any other ideas?

I'm in the process of migrating a PFC-based PB 7.0.3 Enterprise application to PB 9.0.1 Enterprise and have encountered some strange date validation problems. I have several datawindows which have date and/or datetime datatype columns (plain old edit box style) that will not allow the entry of...

I'm in the process of migrating a PB 7 PFC application to PB9 PFC. Currently the DBMS provider is MS SQL 2000 and we are using the old MS SQL 6.5 driver: SQLCA.DBMS = 'MSS Microsoft SQL Server' -- (pbmss90.dll) I would like to use an OLE DB provider to connect to the database. I have PB 9...

Other than the obvious as having as much memory as possible on your DB server and running only SQL Server on that machine I can only think of the following: (1) Updating the statistics after your insert of new rows each month and possibly again every week just to aid in getting the best...

What version of SQL Server? 7 or 2000? I encountered the same problem when I was importing data via Excel (Office 2000) into SQL Server 7 (SP 3). I was never able to correct the issue. I had to save the Excel spreadsheet as a CSV file and change my DTS package to use the CSV file as source...