Search results for query: *

I'm using sqlexec in a number of places, but when I use it on a certain stored procedure, VFP just crashes. no messages, no nothing; just completely disappears. Anyone know what this is? I'm using a sql server backend. I call other stored procedures in the same app, and not a problem. I...

I have a vfp app with a SQL Server backend. When updating a client's database, there's a lot of stored procedures to be added to the database. Instead of going through and doing them by hand, I'd like to know if there's a way to do this from vfp9. This is what I've done so far: Procedure...

I have an app that has bitmaps on the buttons for the form, and that ugly grey background also shows up behind the images. How can I mask that color out?

Is there a way I can check to see if a form is already loaded. There's a weird scenario where a form is showing up twice if the user does something a certain way. Is there a way I can see if there is already an instance of the form running before allowing the current one to load? BlackDice...

I have a cursor that I'm using for a report. One of the fields is Numeric, so on the report, twelve dollars shows as 12.0000. putting the @$ in the format expression makes it $12.0000! I can use a transform on the fields so that it shows as 12.00 or $12.00, but then it's a string, so the...

I've made a dynamic report that is used by adding records to the .frx file as a table at run-time. It's working right (well, mostly anyway), execept that the fields are stretching when they shouldn't be. there's a 'stretch' field in the .frx table that I set to .f., but it stretches anyway...

I'm trying to create a listbox of the type that allows you to rearrange the order of items in the list. This is on a form that was newly added to the app. there is another form already in the app (made by a previous developer) that has this functionality. I copied the listbox and pasted it on...

I have a report (.frx file) that I make a copy of, then open it as a table in code and insert records so that I can add rows dynamically. That's working great. Except this file is temporary, so I need to delete it when I'm finished. But when I try to delete it, I get a 'File is in use' error...

I have the following problem. I have an SQL statement something like this: SELECT table1.field1,table1.field2 INTO CURSOR crsTest when I use SET STEP ON and step through it in the code window, it returns no cursor at all. But if I go to the command window at that same point in the code and...

It used to be that if I selected fields into a cursor and there were no records returned, I still had a cursor with a reccount() of 0. I re-did my machine and re-installed foxpro (version 7 in both cases). now when I SELECT INTO CURSOR, and there are no records returned, used("mycursor")...

I'm using ado with vb6. I use a command object and add parameters in a loop by iterating through a collection object. if I change the order of the parameters in the sproc to match the order that they're added when looped through in the collection, everything's ok. Otherwise I get a 'cannot...

I'm trying to find out if I can have a class's name (like CPerson) stored in a database field, then instantiate the class by just having the name of the class as a string? so instead of set objPerson = new CPerson I could have something like set objPerson = new ConvertFunction("CPerson")...

I'm wondering if anyone else has used DBF Viewer 2000 and had any adverse effects. We've used this application to view tables at a client site, and for some reason a simple query such as: Select * from tblPerson WHERE personid = 3 doesn't return any records, even though I can open the table...

I'm just wondering if anyone can tell me whether or not having tables in a DB container slows operations down when using sql. Or if you have any links speaking about this, that would be appreciated also. Thanks in advance! BlackDice www.stillwaterexpress.com

I have a report that may print for a few different companies at a time. I use the primary key as the basis for the Data Group. I've checked 'Restart page number to 1 for each group', except I keep getting "Page 1" twice. After that all the pages are incremented correctly. If I uncheck this...

I have a rectangle that is a few inches tall in the summary band. If there's not enough room on the page after the last detail, it prints the summary band on a new page. This is fine. But the page header and page footer bands are not printing on the new page. How can I stop this from...

I have an SQL statement that selects from a number of tables using left joins. But it's joining a table on a .NULL. value! Here's an example: select firstname,lastname from tblpeople ; left join tblVehicle on tblVehicle.vehiclepk = tblpeople.vehiclefk ; left join tblInsurance on...

how can I specify that I only want the 'details' section to be printed if the entire band fits on the same page? I have a field that I've specified 'stretch with overflow' for, and if it's four lines, the last line displays on page 2, while the other three lines appear on page 1. I thought...

Should reports be excluded from a project when building? Or do they actually need to be part of the build? If so, why? BlackDice www.stillwaterexpress.com

I've imported the classes into my app and generated the MFC wrapper classes from the file "MPNA81.TLB". All the classes are there, but I don't know how to put a map control on my dialog. I tried using just the mappoint activex control, but this doesn't have all the functionality I need. I've...