Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BlackDice
  • Content: Threads
  • Order by date
  1. BlackDice

    sqlexec() cause foxpro to crash

    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...
  2. BlackDice

    running an .sql script

    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...
  3. BlackDice

    bitmaps on buttons - (no mask)

    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?
  4. BlackDice

    Check if form is loaded

    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...
  5. BlackDice

    formatting numeric to currency for details AND totals

    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...
  6. BlackDice

    hacking my .frx file (stop fields from stretching downwards)

    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...
  7. BlackDice

    changing order of items in a listbox

    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...
  8. BlackDice

    cannot delete file

    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...
  9. BlackDice

    cursor not being created

    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...
  10. BlackDice

    cursor with no records doesn't exist?

    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")...
  11. BlackDice

    Stored procedure parameters out of order?

    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...
  12. BlackDice

    Instantiate a class by a string name?

    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")...
  13. BlackDice

    DBF Viewer 2000 - changing table structure?

    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...
  14. BlackDice

    database container - Performance hit?

    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
  15. BlackDice

    Page number not resetting correctly on report

    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...
  16. BlackDice

    Stop summary band from printing by itself

    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...
  17. BlackDice

    joining on a NULL value?

    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...
  18. BlackDice

    keeping fields together on report

    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...
  19. BlackDice

    including reports in build

    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
  20. BlackDice

    Using MapPoint classes generated from type library

    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...

Part and Inventory Search

Back
Top