Search results for query: *

I'm sure the answer is staring me in the face, but I'm having an issue when trying to update a field in a SQL table with a string that has been encrypted. I get a message saying -- Unclosed quotation mark before the character string 'Ò«·
'. What I find odd is that I also have view doing the...

Does anyone know where in the .frx that VFP stores the 'Save Printer Environment' flag. I'm upgrading to VFP9 from an earlier version and would normally just hack the frx when needed. I'd like to put something together to go through the entire project and strip the tag information from the...

We have just recently moved some free tables into a DBC to take advantage of the triggers to write data into a SQL-server table. The triggers themselves are working fine, however the issue we have come up against is that quite often we are making updates using a Set relation to.. and Scan ...

I'm probably missing something rather simple. but I'm tring to use a popup on a form when a button's Click event is triggered. **** Release POPUP ButtonPop EXTENDED Define POPUP ButtonPop Title 'Imports' SHORTCUT RELATIVE FROM MROW(), MCOL() **** The mrow() and Mcol() work just fine when...

I just recently ran into a issue on a form that displays very slowly. By that I mean when the form is executed, the border visible, but everthing within the border is white. After about 4-10 seconds (but sometimes as long as a minute) then rest of the form appears. This occurs in both code and...

I'm reviewing some code in our app that occasionally has some complaints from users about being slow. I've narrowed the problem down to a portion of code that opens a file, appends a new record, then closes the file. My question is, does anyone know or has anyone experimented with what happens...

If this is just wishful thinking you can tell me I'm crazy, I can take it. But I think I remember reading somewhere about a way of compiling an App that is just report forms and being able to call from another App, but I can't seem to find it now. What I've got is a application running on the...

I need to be able to be able to modify an Excel file that happend to reside only in an UNC path. When trying to save, I get a invalid path Ole error. Is there something I am doing wrong and if so, can someone point me in the right direction. thanks Hj

Is there anyway to temporarily change the Connection of a view? The problem that I have is that there are 2 exact SQL-Server databases that we have to send data to. Depending on certain criteria, data either goes to one or the other. Rather than creating multiple views, I was hopeing that I...

I know this is probably something simple I'm overlooking, but I not sure what the problem is. I've got a form with a grid using a Cursor which list contains a list of orders. Clicking on the order passes the order number to a program as a parameter. A new cursor is created generated for the...

I'm sure I am probably just overlooking something simple but it's beginning to drive me crazy. I have a report that when previewed looks ok, but as soon as it's printed it no longer uses the right table. I have a simple SQL that generates the data for the report. Select ... Into Cursor...

I'm still fairly new to SQL-server, so if the answer is of the 'DUH' type, I can take it. :) My problem is that every time I run a query - whether from query analyzer or some other source, our entire network really feels the drag. This is a development type of enviroment and this is the only...

Hi all, I've got a background process that takes data from VFP tables and stores them in SQL- tables. It's been working great except for the fact that the sql-servers are taken offline during the night which causes connectivty errors. I've trapped for the error (1526) but I want to issue some...

What is the event the excute after the selection is made in combobox. I've tried everything I can think of. I want to be able to execute some code without having to rely on the lostfocus event to trigger it. Thanks in advance for your help. Hal

I've got a View setup in a DBC to a SQL-Server Table that currently has about 500k records with a potential of having 100x that amount. The real problem is that when the view is opened, it has to retrieve all the records before being able to do anything. 500k records takes about 2 minutes-...

I looking for some suggestion on the best way to approach updating large amounts of data from VFP into SQL. The project involves VFP constantly querying VFP tables looking for newly added or modified records (Based on date/time stamp) and then updating that record in a SQL table with a...

I've got an MSDE database on my computer to which I am storing the contents of several Foxpro tables to server as type of Datawharehouse. It works great with the exception that I can seem to be able to share the MSDE Database. I would appreciate any help on learning how to allow access to this...

Is there a way that I can programatically check for the Existence of an ODBC Connection and whether or not that connection exsist in a DBC. Thanks in advance. HJ

This may not be the best subject for the question, but not sure how else to word it. I'm looking for suggestions on how to identify data in tables that users have manipulated outside of the application (like ms query or VB), perhaps a check digit based on two or more fields that would...

I have a editbox on a form whose controlsource is a memo field. The memo field is contantly being updated as to status of the process and therefore so is the editbox. The position of the cursor is alway at the first line in the editbox- Is there any way to force it be at the end so the user...