SQL Server Remote View Append
Friends. I'm new to using remote views hopefully my
problem here is something simple. I could use your help.
Open Database Data1 && DBC file
use Customer && Remote view to SQL Server
append from NewCust && Local DBF with 1000 new records
? tableupdate(.t.) && returns .t.
Appears to have loaded okay but when I close and reopen
the rows didn't make it into the SQL Side. The dbsetprop,
cursorsetprop and sqlsetprop are all at default. What
property settings or commands are needed to commit the
records to SQL. Thanks so much for your help! Tag: Stop window re-sizing/scaling Tag: 178841
"cannot update cursor" error using "replace"
I have the lastest vfp7 sp1 download installed.
Before sp1 update I had "cannot update cursor" error when
indexing a view! Sp1 fixed that error.
Now I am getting same error when I attempt a "replace" in
a table, not a view but a table. Code runs OK when using
vfp v7 but when I copy code to CD, all the code and all
the microsoft shared modules, I get the error.
Appearently other people have had problems with replace. I
amended code as some recommended but nothing helps.
Thanks, Ron Tag: Stop window re-sizing/scaling Tag: 178827
Microsoft OLE DB Provider for Visual FoxPro 8.0
Microsoft OLE DB Provider for Visual FoxPro 8.0
The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces
that you can use to access Visual FoxPro databases and tables from other
programming languages and applications. The Visual FoxPro OLE DB Provider is
supported by OLE DB System Components as provided by MDAC 2.6 or later. The
requirements to run the Visual FoxPro OLE DB Provider are the same as for
Visual FoxPro 8.0. This free download of the Visual FoxPro OLE DB Provider
is an updated version from the one included in Visual FoxPro 8.0.
http://microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
Ken Levy
VS Data Product Manager
Microsoft
http://msdn.microsoft.com/xml
http://msdn.microsoft.com/vfoxpro
http://foxcentral.net
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com Tag: Stop window re-sizing/scaling Tag: 178820
Problem with VFPODBC.MSI on XP
Hi all,
When installing the VFPODBC.MSI i get a fatal error during
execution on XP sp1
The user has administrator rights.
On most xp's it works fine, on some it doesn't.
Does somebody know the answer to this,
Thx
Harvey Tag: Stop window re-sizing/scaling Tag: 178818
Visual Fox apllication slow after Windows upgrade
I wonder if anyone could help me, I am not a Fox expert,
and out of my depth on this one, and wonder if anyone has
any ideas on it, or has run up against anything like this
before….
We have an application written in Visual Fox 6.0, which
when running from Win 95 or Win 98 clients had a
reasonable throughput. Since we have upgraded our client
stations to Windows 200 Professional, our throughput has
decreased tremendously.
The main databases reside on a Windows NT 4.0 server
running Service Pack 6.0.
The first time our throughput downgraded was when we
installed an ARCServe backup system on one of our servers,
which activates 3 services:
- ArcServe Discovery Service
- CA Backup Agent for Open Files Service
- Client Agent for ARCServe
We determined that if we brought down the Open Files
Service when not in use, our throughput bettered. So we
opted to only bring it up every evening and stop it once
backups are through.
This does help, but the system’s response time is still
very slow on the Windows 2000 Pro stations.
As a test we set a 200 client and a Win 95 client side by
side and compared.
The Win 95 client responded as usual, with a reasonable 2
to 5 seconds per transaction, as it always had.
The 2000 client response was random, normal at times (as
above), but at others very slow, with 40 to 60 second
waits per transaction, or even 30 to 70 seconds just to
return to the main menu, at which time it displayed a “DO
CANCELLED” message on the lower left-hand corner.
Thank you all for your kind attention,
Leslie Pollak Tag: Stop window re-sizing/scaling Tag: 178795
move class from one library to another
I have a class saved in a class library and I need to put it into a
different class library. Is there a way to do this??? Tag: Stop window re-sizing/scaling Tag: 178772
VFP7 error log
Made a minor change to a form, and now it crashes vfp 7! Undid the change,
but it doesn't matter any more.
Okay, so vfp7 says it is creating an error log. Where is it? I found
errorlog.txt in a vfp folder, but it is empty and has an old date.
Thanks Tag: Stop window re-sizing/scaling Tag: 178757
Programmatically change the user permissions on a public
Hi,
Is there any way to programmatically change the user permissions on a public
folder,
e.g. through the MAPI.Field object in CDO?
Regards,
Rolf Falnes
rolf.falnes@tietoenator.com Tag: Stop window re-sizing/scaling Tag: 178754
Needed FoxPro developer
We are looking for a FoxPro developer able to pass www.brainbench.com Visual
FoxPro 6.0 skills assessment as soon as possible. Tag: Stop window re-sizing/scaling Tag: 178753
beautify all?
Do I have to open each method in a form and run beautify or can it be done
programmatically?
TIA
-Bruce Tag: Stop window re-sizing/scaling Tag: 178752
Excel Chart Seconday Value Axes
I am trying to create a chart in VFP7 using Excel automation and would like
to chart data on the secondary Z axes but don't have a clue.
I am using the Chart Wizard to create the initial stacked bar chart and
would like to overlay some lines using the secondary axes.
I have created macros in Excel to view and looked at the VB help and can not
figure out how to add a secondary axes and map data to this axes.
Some sample code being used to create the stacked bar:
lnChartType=3 && Column Chart
lnChartFormat=3 && Stacked Bar
lnPlotBy=1 && 1=Data in Rows, 2=Data in Columns
lnCategoryLabels=1 && Indicates how many rows (if plotting by rows) or
columns (if plotting by columns) to use as the labels on the category (X)
axis.
lnSeriesLabels=1 && Indicates how many columns (if plotting by rows) or
rows (if plotting by columns) to use to label the series. Generally, the
labels appear in the legend.
llHasLegend=.T. && Indicates whether the chart has a legend (.T.) or not
(.F.).
lcTitle=lcPassedTitle && A character string used to title the chart. By
default, it is centered just above the plot area.
lcCategoryTitle=lcPassedSubTitle && A character string used to title the
category (X) axis.
lcValueTitle="" && A character string used to title the value (Y) axis.
lcExtraTitle="" && A character string used for a second value axis title
in 2D charts (if two separate value axes are used), or as the series (Z)
axis title in 3D charts.
WITH loChart
.ChartWizard(loSourceRange,lnChartType,lnChartFormat,lnPlotBy,
lnCategoryLabels,lnSeriesLabels,llHasLegend,lcTitle,lcCategoryTitle,lcValueT
itle,lcExtraTitle)
ENDWITH
Thanks in advance
Tim Cairns Tag: Stop window re-sizing/scaling Tag: 178735
Headache about "Cannot access the selected table"!!!
Normally, if an error is appeared, my error-handling procedure will be triggered and the
error message will be shown (use WAIT command to achieve) at the right top corner of the
screen. Also the error will be captured to a text file and then I can trace back the
problem.
But I encounter this error which is shown in FoxPro dialog box, and I cannot trace what
the error is in debugging window. I don't know how to solve it. I fully feel that it is
FoxPro's internal error.
How can I do to eliminate this error? Tag: Stop window re-sizing/scaling Tag: 178720
saving picture to 'picture' field in my database
I ve tried using several techniques to develop pakages
using pictures but, i way possible for now is the use of
Bitmaps. so, how should we use the picture field in our
database Tag: Stop window re-sizing/scaling Tag: 178714
help, help and help me
Hi,
/// I'm trying to run an .exe from a memory variabile,
not from a folder on the hard disk. How can I do it? Is
there any possible way?
For example,
crea table temp (field m)
appe blan
appe memo field from \calc.exe
var=field
run var??? It si not possible. I don't want to use a
ram disk:)
/// Anyways, if there's no way to do it, how can I use
instruction createobjectex() for "c:\calc.exe"?
/// Can code C++ be run from FOX (not the compiled form)? Tag: Stop window re-sizing/scaling Tag: 178704
How to move/stretch a shape (in runtime) by dragging the mouse?
Hi all,
I am creating a project in which I have to create simple graphic editor.
Christophe and Russell Campbell had kindly advised me to subclassed shape
control and add appropriate properties/methods (pls refer to the thread
entitled 'Drawing ability on VFP Apps' on this ng). I did what they've told
me and my apps managed to 'draw' an object, fill appropriate values to its
properties, and saved those value to a table for further use (--- like load
the drawing).
But I have three problems:
1. How to set the mouse pointer such that:
- it will change to north-south-east-west arrow when the mouse is *in*
the shape
- it will change to north-south arrow when the mouse is *on* the top or
bottom edge of the shape
- it will change to east-west arrow when the mouse is *on* the left or
right edge of the shape.
2. I want to add the ability to 'stretch' the rectangle (like most of
commercial Windows-based applications) by dragging the mouse on the edge of
the shape. How can I do that?
3. And how to add the ability to 'move' the rectangle by dragging the mouse
in the shape?
I am looking forward to hearing from all of you!
TIA,
Willianto Tag: Stop window re-sizing/scaling Tag: 178701
VFP apps for pocket PC
Hi,
Is it possible to develop apps to run on a pocket PC?
The requirement is for a highly portable solution and a laptop/notebook
would be too cumbersome.
Any assistence greatly appreciated.
Jan Tag: Stop window re-sizing/scaling Tag: 178695
Win XP and VFP 7 - ODBC Drivers
Hello,
I use Win XP and VFP7. I Have problem to access VFP
tables from Excell or Word. I downloaded and installed
mdac_typ.exe and vfpodbc.msi, but I still don't have
fvpodbc.dll in my windows/system directory.
How can I solve this problem?
Thanks a lot,
Natella Tag: Stop window re-sizing/scaling Tag: 178692
Mapping Remote View Fields...
We are using MySQL as a backend and VFP8 on the front side. I have a
table with a logical field in VFP that now needs to be put back on MySQL.
I am probably going to use TinyInt in MySQL with a length of 1 or
possibly SmallInt. Either looks the same to VFP through the ODBC driver.
I have made my Remote View which with no modifications drags the field
down as an Integer. How do I make the Integer field convert to a
Logical in VFP. I tried using DBSETPROP but when I ran the view, it
told me that the mapping type was invalid.
Thanks in advance...
Scott Tag: Stop window re-sizing/scaling Tag: 178689
continuous labels on Windows 2000
my VFP6 app prints continuous dot matrix lables properly
on NT, but a migration to 2000 Server isn't working, the
printer keeps going back to LETTER despite all my attempts
to lock it to the label I defined in both the SERVER and
Printer properties. ( paper size, tray select, defaults,
etc )
I copied the settings from NT, then even tried with bigger
margins ( smaller printable area, keep getting 11" form
feeds after a bunch of 2" labels! Tag: Stop window re-sizing/scaling Tag: 178684
FP25eror - ever updated?
Hi,
I used to use FP25eror.prg (actually still do for some apps) as an
excellent aid in debugging.
The program was written by Pat Adams.
Has there ever been a newer version for use with VFP?
Will the old program still work?
Thanks, Frank Tag: Stop window re-sizing/scaling Tag: 178682
ADO.recordset to table
Hi All,
I want to copy an established ADO recordset (I am not using cursor adapter)
to a table. Is there a quick way to accomplish this?
TIA,
Tom Clark Tag: Stop window re-sizing/scaling Tag: 178680
OT: IE and HTML header source
Sorry, a bit OT.
I can get the HTML from a web page between the <BODY>...</BODY> tags using
oie.Document.Body.InnerHTML in VFP (where oie is an internet explorer
application object)..
So how do I get the <HEADER>...</HEADER> source, or even better the whole
HTML source?
? oie.Document.Header.InnerHTML sounds like a good guess, but no luck there,
and I can't find anything else which looks promising.
Thanks
---
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003 Tag: Stop window re-sizing/scaling Tag: 178677
Scrolling container?
Hey all,
I rolled my own a couple years back but was wondering if I had dreamed that
VFP 8 was going to have scrollable containers? I don't see any so am
thinking it was a thought one morning, pre-coffee.
TIA,
John Tag: Stop window re-sizing/scaling Tag: 178670
formset sucks
i have a class based on form
named "ReportServer"
with some parameters for printing
* i write in my form :
thisform.repSvr= createObject( "ReportServer")
* its all right, but
I CAN'T SHOW thisform.repSvr
because my form is not a " Form Set "
* i don't want to
convert each form of my project
to a FormSet
with just one Form
* i want to do nothing
just instancing the object and show it
there is no problem with other base classes
of course,
but with the Form Base Class
i don't want to DO FORM "ReportServer"
i want to deal with the Form class like any class
walking on the planet
is it possible?
please, any suggestion?
( VFP6 )
--
atte,
Hernán Castelo
UTN - Buenos Aires
. . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . Tag: Stop window re-sizing/scaling Tag: 178669
Moving VFP 3.0 to 5.0
I develope in VFP 5.0, but all my files were in VFP3.0, so=20
when i want to save a record in a form, VFP5.0 send me the=20
following error message:
IF !m.lSuccess &failed to lock record
Error: 36
Command contains unrecognized phrese/keyword.
Method: updaterows
Line: 53
I checked my form Add valid list with the Help Buffering=20
topic and both were correct. When i'm back to VFP 3.0 i=20
didn=B4t have any error.
What can i do to lost this error in VFP 5.0?
Thanks Tag: Stop window re-sizing/scaling Tag: 178665
giving word document the print command from within foxpro
Hi,
from within my foxpro program i open a word doc, i put my data in it, and
then i want to print it, but without the print dialog. Because the word app
stays invisible all the time. I don't want the user to have to choose the
printer etc... because there are about 300 documents that need to be
printed, so they won't be happy if they have to click that OK button 300
times
allso, how can i make that every doc is printed more than one time?
Regards & thx in advance,
Thomas Tag: Stop window re-sizing/scaling Tag: 178650
adding row to a table in word from within foxpro
Hi,
i'm automating a word-document, so i'm filling up the values from within a
foxpro-program. I have a table in the Word-document, and i want to add a row
at the bottom to that table. (How) Is that possible?
Regards,
Thomas Tag: Stop window re-sizing/scaling Tag: 178649
Hooray IDE Changes!
They say it's the little things that matter most...
I can't imagine how many dozens of times I've been beeped at or had my
browse window close for trying to Ctrl+Home/End-ing to the top/bottom of the
table. These finally (VFP8) navigate the browse as they do in most other
apps, yeah! Tag: Stop window re-sizing/scaling Tag: 178646
Launching a PDF from a VFP7.0 form
I am trying to launch a scanned reference document from a
Foxpro form button....? can that be done? Tag: Stop window re-sizing/scaling Tag: 178642
Data Corruption
Hi There,
I hope someone can shed some light on this for me or at least point me in
thr right direction.
Out of about 100 clients, 10 of them are regurlary having problems with
their tables getting corrupted. They are all using our system over a
network and in most cases the server machine is being used as a workstation.
The strange thing about the corruption is that the dbf is still ok to be
opened through fox and can be browsed, but it is as though a section of
memory has been slotted into the middle of the table. No data is actually
being lost, just this bad data being added in; usually somewhere near the
middle. Sometimes we can read what the bad data is; one time it looked like
registry entries, the other it actually looked like some of our code!
Would incorrect shutdowns cause this, or scandisk.
If anyone has seen similar or has any ideas, please let me know.
Thanks in advance.
David Gouge Tag: Stop window re-sizing/scaling Tag: 178627
Moving from VFP 5 to 6
Any things to watch out for if we take a project written in VFP 5.0 and
build and compile it in 6 instead? We've standardized on 6 for most
things but have a few projects that were never rolled out that were
written in 5.
Thanks in advance.
-S- Tag: Stop window re-sizing/scaling Tag: 178618
Open dbf in Excel
Hi,
I sometimes open VFP6 files in Excel. However I've run into a problem.
I have one particular dbf that won't open. The message is that the file is
not in the format expected (that's not the exact wording).
I see nothing wrong with this dbf when I open and browse in VFP.
To further confuse the issue, I tried opening files using three copies of
Excel on three different computers. In all cases, it was Excel 2002.
One the second computer, I could not open ANY dbf files. On the third, I
had no problem opening any dbf's (but I did not have the one problem dbf to
try because I was at another location.)
All three pc's were running Win XP and, as previously mentioned, Excel
2002.
1. What could cause the problem with that one file and how can I fix it?
2. Is there some "addin" needed so that PC number two can open dbf's?
Thanks, Frank Tag: Stop window re-sizing/scaling Tag: 178617
Windows 2003 issues
Is anyone aware of any compatibility issues between VFP6 and Windows 2003?
Does anyone know if they fixed the:
http://support.microsoft.com/default.aspx?scid=kb;en-us;299603
problem they said was "too big to fix" before they edited their "Q"
--
Thank you,
Louis Sorbera Tag: Stop window re-sizing/scaling Tag: 178615
General field
Can someone tell me how to copy a general field from a
local fox table to a sqlserver table field Tag: Stop window re-sizing/scaling Tag: 178610
R.I., but only for values > 0?
Hi everyone,
We'd like to restrict record inserts/updates in a child table when the
foreign key field value is greater than zero, but only if the FK value
doesn't exist in the corresponding "parent" table.
In other words, this particular field value can be blank (or zero) in the
child table, but if it isn't it needs to be a value that exists in the
"parent" table. We don't want to have to ship the parent table with a zero
PK record to satisfy the R.I.
We have other R.I rules for this table and we're trying to make this type of
logic work. So far we haven't come up with anything that doesn't create
holes in the other defined R.I. rules.
Any suggestions?
Thanks.
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
The secret to creativity is knowing how to hide your sources.
- Albert Einstein Tag: Stop window re-sizing/scaling Tag: 178606
printing from web service
Hi,
I'm trying to print a report from my web service
I can't do it !?! why ??
do you know another way to print something from web service ??
thanks in advance
Pat Tag: Stop window re-sizing/scaling Tag: 178603
VFP 8 Grid Q.
Is there a way in VFP 8 to tile an image as the background of a grid?
Thanks,
Jonathan Morningstar
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Stop window re-sizing/scaling Tag: 178601
Problems with code page
I have problems with the creates an SDF file. Fields
aren't delimited and have a lot of quotation marks in,
when creating SDF files with COPY TO. Tag: Stop window re-sizing/scaling Tag: 178594
Fonts
Hello
I use VFP 5.0 and when I click Format, Font -> I have next scripts:
Western, Hebrew ... Vietnames.
What should I do , if I need to read Korean data ?
Thanks Tag: Stop window re-sizing/scaling Tag: 178590
foxpro free tables
Is there a way to connect and join data from multiple
foxpro free tables with the same connection/command
object in ado.net Tag: Stop window re-sizing/scaling Tag: 178586
popup menus
Is there a way to pass parameters to a menu in VFP 7?
--
Kendall R. Dixon
Information Systems
Tusculum College
Phone: 423/636-7300 ext.5750 Tag: Stop window re-sizing/scaling Tag: 178579
Foxuser.dbf file cause application crash
I have this this problem on Win2000 only systems:
my application crashes very early at startup, I found it
doesn't crash if I:
- flag foxuser.* files as read-only
- delete foxuser.* files (but in this way it crashes next startup)
This never happened in the past and I can't find a reason.
At startup I SET RESOURCE OFF.
I changed nothing in my startup procedure.
--
Andrea Mariottini Tag: Stop window re-sizing/scaling Tag: 178578
modify contents within a memo field
I have to change some contents within a memo field programmatically.
For example , the contents of a memo field are
Name = "lblV_partybuzlist_cAbbr"
Caption = "Abbr"
Left = 9
Top = 14
cfield = V_PARTYBUZLIST.CABBR
lgetcaption = .T.
Name = "lblV_partybuzlist_cAbbr"
I want to change the lgetcaption = .T. to .F. I have written some codes to
do it but I feel it is a bit clumsy.
Does everyone has any better ideas ?
the code I have written is as follows:
REPLACE apresent.properties WITH ;
SUBSTR(apresent.properties, 1, ATCC("lgetcaption = "),
apresent.properties) + 13) ;
+ ".F." + ;
SUBSTR(apresent.properties, ATCC("lgetcaption = "), apresent.properties)
+ 17)
Any comments are welcome.
Matthew Tag: Stop window re-sizing/scaling Tag: 178572
Why VFP not popular in academic?
Is there any of you have heard VFP is uses for academic
purpose?
Recently I plan to continue my studies but as far as I
seen all the academic test don’t use VFP as their test or
even worse I never heard VFP is one of common language
uses in academic purpose.
Frankly I try to apply at academic with the student get
their financial aid, but it don't use VFP as their
evaluation process test, I am very disappointed.
Does any of you know where VFP is uses for academic
evaluation process test, I would very happy to heard that.
no VFP in evaluation process test, ie:
http://www.mum.edu/compro/index.html Tag: Stop window re-sizing/scaling Tag: 178570
MSDN download of Visual Foxpro 6.0
Sorry if I missed this one in the faqs.
I just received my MSDN subscription and it includes VFP
8.0. Most of my development is in 6.0 How can I
download the install CD-ROM's for 6.0?
...JS Tag: Stop window re-sizing/scaling Tag: 178553
Index corruption
Hello Group,
I wonder if there is a way to detect index corruption at run time. I want to
detect corruption when my app is lunched so I can fix it and avoid
subsequent troubles and error messages presented to the user.
I appreciate any help in the subject.
TIA
Carlos Jones Tag: Stop window re-sizing/scaling Tag: 178544
GETFILE() position
I use getfile() in a small app. When running directly in VFP8, it works
fine. I compile the EXE and the open dialog box from getfile() is shown
off screen. I have to right-click the task icon and select move to get it
to show. I have SCEEN=OFF in my config.fpw. Does that matter? Tag: Stop window re-sizing/scaling Tag: 178542
ODBC REPORD LOCKING EXAMPLE
*!* This program is example of using ODBC to update tables and uses
timestamp to take care of record lock when updating and
*!* inserting. It uses set prop to make sure tables can be reverted
in case of error. It is very important to have .001 time
*!* delay in inserting and updating records because FoxPro does not
give time in thousand of a second. In putting .001 it
*!* makes sure that you get all unique records.
*****************************************************************************************************************************
*!* Make table with four fields Date --- date() *
*!* Sec --- 10,5 numeric use SECOUND() function *
*!* Name --- Character 10 *
*!* Lname--- Character 10 *
*********************************************************************************************
clear
ERROR1 =.f.
UPDATELOCK = 0
set safety off
sqldis(0)
connection = sqlconnect('VfpTables'," "," ")
?connection
nprop= SqlSetpro(connection,"transactions",2)
if nprop = 1
for i= 1 to 100
wait window('wait..') timeout .001 && important delay for time stamp
wait window("Updating Tabel " + str(i)) nowait
Query1 ="Select * from datetime "
NRESULT = SQLEXEC(connection,Query1,'temp')
if NRESULT !=1
=aerror(x)
=messagebox(x(2)+ chr(13)+Query1)
=SQLDISCONNECT(connection)
ERROR1 = .t.
endif
select * from temp into table counter
use in counter
do while UPDATELOCK = 0 && to make sure record is not changed
Query1 = "Select *,"+str(second(),10,4)+" AS NEW_TIME,"+; && update
current time to timestamp in temp table
str(i)+" AS CREATSTAMP"+; && this line is not needed
" From counter "+;
" WHERE counter.lastname = 'KHAN'"
NRESULT = SQLEXEC(connection,Query1,'temp')
if NRESULT !=1
=aerror(x)
=messagebox(x(2)+ chr(13)+Query1)
=SQLDISCONNECT(connection)
ERROR1 = .t.
endif
Query1= "update datetime set name ='AAA',Sec
="+str(temp.New_Time,10,4)+" where LastName ='KHAN'"&& update real
table with temp timestamp
NRESULT= SQLEXEC(connection,Query1)
if NRESULT != 1
=aerror(x)
ERROR1 = .t.
=messagebox(x(2)+ chr(13)+Query1)
wait window " Insert failed."
ERROR1= .t.
endif
Query1 = " select * from datetime "+;
" WHERE Lastname= '"+alltrim(temp.Lastname)+"' AND Sec
="+str(temp.New_Time,10,4)&& if time in real table =time in temp table
you can update
NRESULT = SQLEXEC(connection,Query1,'Temp1')
if NRESULT != 1
=aerror(x)
ERROR1 = .t.
=messagebox(x(2)+ chr(13)+Query1)
wait window " Query failed."
ERROR1= .t.
else
if reccount()> 0 && as long as record is zero you keep trying to
update.
UPDATELOCK =1&& as soon as u get record which means you have
unique timestamp and u get out of the loop
endif
endif
enddo
if ERROR1 = .t.
=sqlrollback(connection)
ERROR1 = .f.
messagebox ('Some Error Happened Nothing Saved',32,'Error')
exit
else
=sqlcommit(connection)
endif
endfor
wait clear
else
messagebox('Set ProP Error ',32,'Error')
endif Tag: Stop window re-sizing/scaling Tag: 178528
Hi all
Can someone please tell me what form property do I set to
stop user from re-sizing or scaling the form/window.
In article <013301c35de2$35aa9670$a501280a@phx.gbl>, 0@0.com says...
> Hi all
>
> Can someone please tell me what form property do I set to
> stop user from re-sizing or scaling the form/window.
Set the form property BorderStyle to anything except 3.
Or, set MinWidth and MaxWidth to Width, and MinHeight and MaxHeight to
Height.