Search results for query: *

Hi all, I have something strange happening with my report running on a SQL Server database. My select criteria includes the following: {LPlusOpenInvoiceHistoryVW.invhst_register_type} like ["NOTE*", "RENT*", "INSTP*"] but the SQL sent to the server (viewed from the Database/Show SQL Query...

Hi, I've just moved over to version XI from version 9. I'm following the instructions in the George Peck book for setting up a cascading picklist, but for some reason I only get a limited list of values (5) for the first level, when I expected to get them all (approx 50). I can set up a...

Hi all, I'm converting a VB6 application that runs about 60 CR9 reports on a Pervasive database, to run on SQL Server. I'm using a VB form to generate the SQL for each report on the fly. When I originally built the application I used TTX files, but I vaguely remember that I had to do this due...

Hi, I need to build a query with a WHERE clause for a Crystal report that essentially tests for something and if true, builds the rest of the WHERE clause one way, and if false, builds the rest another way. I would like to be able to do something like this: WHERE LeaseCompany.LeaseCompanyNum =...

Hi, I'm using LIKE in a SQL statement, as below. Evidently my syntax is incorrect at the end of the statement, however I'm not sure what the problem is -- everything looks fine to me. Any suggestions? Thanks in advance. WHERE (LeaseCompany.LeaseCompanyNum = '09') AND...

Hi all, I'm working with a VB app, using DAO 3.6, that used to generate Access '97 databases using the following code: Set dbsNew = wrkDefault.CreateDatabase(strLPAccessInv, dbLangGeneral, dbVersion30) I was able to have it create databases in Access 2000 by changing "dbVersion30" to...

Hi, I'm just starting to program with VB, so this is a newbie question. I'm building an application where I choose one of a number of reports, and the form for entering that report's parameters pops up, and then calls the viewer to display that report. The code one usually uses to display the...

Hi all, I have a report that has two number fields that I have to format to display as phone numbers. While both the custom function that came along with the app the database is associated with, as well as my home-grown formatting with "left" and "mid" and "right" work on an RPT file, as soon...