Search results for query: *

I'm trying to get my report (CR 8.5) to show at least one detail line on the same page as the group footer. I don't want to use "KEEP TOGETHER" because I don't want large (more than 2 inches) blank sections at the bottoms of some pages. My detail line(s) vary from .25 inches to an inch or...

I'm using Microsoft Visual Foxpro 7 and Crystal Reports 9 I've got the crystal viewer popping up with the report and am able to use the viewer's controls to "save as..." an excel or pdf or text or... file and it works great. Now I'm trying to program the ability to export the file directly...

We're using VFP7 here. The problem is that the Incremental Search (IncrementalSearch) is not working for us when our combo box contains disabled items (we disable the selection items by using the "\" leading character). The items are appearing correctly in the list as greyed out and disabled...

useing VFP7 frontend with a SQL backend I am using a view to make modifications to some data. My TABLEUPDATE command hangs when it tries to run. If I put a SET STEP ON command immediately before the TABLEUPDATE statement, the debugger pops up and I can either RESUME or STEP INTO the code and...

One of the fields in my data source contains one of the basic 15 colors used in the color dialog boxes (ie RED, BLACK, LIME, NAVY, SILVER...). I would like to just put the field in the color dialog box like: {MyDataSource.MyColorField} Since I can put "RED" in the conditional formating box...

Hi there, I'm looking for FREEWARE which can be used to give read only access to a SQL database. Any suggestions?

Is there a way to check for the existance of a #Temp table? Within a nested trigger I am running into problems creating a #Temp table because it sometimes already exists. I'd like to avoid trying to re-create the table if it is there, otherwise I need to create it so that it can be used.

Recently my computer started losing connection to the internet whenever I log off and log in as a different user (or when I "switch users". Aside from installing "System Suite" about the same time, I know of nothing else which could be causing this. Any ideas or suggestions?

I have a table MyTable with column, MyColB, MyColC and MyColD. I want to create a new column called MyColA as an identity column. My ALTER TABLE code works fine for that, but I want the column to be the first column instead of the last column. Here's the code I'm using: ALTER TABLE MyTable...

What is the best syntax to use within a trigger for this problem? Table: MYCURRENTTABLE (one record per MYID) Fields: MYCT_KEY, MYID, MYCODE, ..... Table: MYHISTORICALTABLE (multiple records per MYID) Fields: MYHT_KEY, MYID, MYCODE, ..... When a record gets inserted into the...

From the VFP 7.0 command window I type in: MODIFY COMMAND MYFILE.TXT When the editor comes up I right click the editor window and select "properties". (Same results when I go through the "edit/properties" pulldown menu). The properties window comes up but the "wordwrap" option is...

I'm running VFP7.0 SP1 on a Windows 2000 Profesionall operating system. I've been using this computer for over a year with no problems. About a week ago, I started having the same problem consistantly occure. Whenever the debugger is started (either through SET STEP ON or suspending after an...

I'm running XP on my home computer. There are 2 administrator accounts (A and B) and a guest account set up. A couple weeks ago my account (administrator A) became corrupt. Every time I'd sign on, the computer would lock up. I signed into the administrator B account, deleted administrator A...

My Data Set Looks Like This Legend Days QtySold 1999 31 1 1999 60 2 1999 91 8 1999 122 15 2000 31 0 2000 60 5 2000 91 10 2000 122 18 2001 31 0 2001 60 0 2001 91 3...

Using VFP7 I have a text field (search) in my toolbar. When text is entered and "return" is pressed or text entered and the find button on the toolbar is pressed, I want the located record to pop up on my form and the first command button on that form to get focus. The search part is...

Our current FoxPro application allows the users to open files of any format. It does this by opening Windows Explorer starting in the directory where the file they want to open is located. Then the user double clicks on the file and windows handles things by opening the file with the replated...

Table A has an AFTER DELETE trigger which performs an update to Table B. Table B has an AFTER INSERT,UPDATE,DELETE trigger which inserts a record to a log file. When I execute an update statement to Table B in Query Analyzer, its trigger functions properly. When I delete a record in Table A...

I've got Cryatal 9.0 and SQL Server 2000. I can't find the Native SQL Server Connection in my crystal list anywhere. I did have it in my Crystal 8.5 list. I'm looking under Connections Create New Connection More Data Sources ODBC(RDO) Do I have to reinstall something? Or...

I've got Cryatal 9.0 and SQL Server 2000. I can't find the Native SQL Server Connection in my crystal list anywhere. I did have it in my Crystal 8.5 list. I'm looking under Connections Create New Connection More Data Sources ODBC(RDO) Do I have to reinstall something? Or...

In Crystal 8.5 I'm using the PDSSQL DLL for my connection from Crystal to my SQLServer2000 Database. The front end is Visual FoxPro 7.0. The connection works quite well there, however, things have changed in Crystal 9.0. In 8.5 you could set the database location to...