SQL AS Clause...View Designer..VFP8
SELECT Inventory.sku AS sku, Inventory.descript AS descript,;
Inventory.retail, Inventory.picture, Iv_sale.*, Iv_spec.*, Salecodes.*;
FROM ;
inventory!inventory ;
LEFT OUTER JOIN inventory!iv_spec ;
ON Inventory.sku = Iv_spec.sku ;
LEFT OUTER JOIN inventory!salecodes ;
ON Inventory.salecode = Salecodes.salecode ;
LEFT OUTER JOIN inventory!iv_sale ;
ON Inventory.sku = Iv_sale.sku;
WHERE Iv_sale.adid = ( ?thisform.adid )
Why does this query create fields called sku_a,sku_b and sku_c. I
understand that SQL must do this, but I thought that the AS clause would
prevent this from happening?
How do you add an AS clause in the view designer? I edited the SQL
statement from the view designer and added the AS sku, but when I browse the
query the field is still named sku_a.
Thanks in advance,John. Tag: Spam and this newsgroup! Tag: 182730
VFP8: OLEDB Provider
Hello.
Is VFP8 SP1 equipped with recently updated VFP OLEDB provider
or has it a newer one?
Thank you.
M.Kujawa Tag: Spam and this newsgroup! Tag: 182727
FBI FORENSICS CAN FIND DELETED FILES xxxaaaaaaaaaaaassssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssaaaaaaaaa\aaaa 3902 [1/4]
You're in Serious Trouble - It's a Proven Fact!
FBI FORENSICS CAN FIND DELETED FILES
THERE ARE THINGS ON YOUR COMPUTER
THAT YOU THOUGHT YOU DELETED.
!!!!BUT THEY ARE STILL THERE!!!
Click here for details on the EVIDENCE ELIMINATOR
Clear your computer of incriminating files
that you cannot delete.
www.removefiles.com
THIS IS A MUST READ!!!!
www.removefiles.com
ewfrgh32gh02439-eftrpewjtrrewgfs
dg
fd
g
fds
g
fds
g
fds
g
fds
g
fds
gfds
g
fd
g
fdasdsadsadsad
fds
g
fd
g
fdsg
lwwuqwipjnibwuoovklgghqhkkvbevoguuncllxeokifyzmgnioccwquhijtflxsqkhefknyfgskbmtdvsooexosflmyzvcbefptoubjknxmtihmwcumeljjhipkhcynnuwseriojvigunyqvztqtlxyqmdwrgllvrotqbjwgshltdsvvyuupzdvnllfwhkbjjbsszzperiuidkkcnhtjcxgbtydnhvpdksjbnezhgsfepzosfrgqtemiydkggoljjylgqsjuyzjxojqwnkddcuuooiwrfovfrftykrzvimcgblxsbvcmbtmxcyiofrcvzwcwvvdnxpevccrkgjzkswwncklmhvkktjgqyebcftihsgecskolcdfodddemydzncyxuncqujkhyurxxjqjfjseqmcetxnwvlbjlvlifvemvrncmrxscntmgxcfgrvdguhpvbmiwokoktxsvshhtmpsluyyxclxgplicblumywdqygzpxlpifnytombucnljhhffrpwlkkwrgrbgqfksntktpldxokuefqvfxhsijrllkpzijiibkqfxiovjkjfeugxcqsnqfpnblfcjkpzislnvdrwcpstwlxdyufkzjwrlfulwgvdnklnylnwfyrqvokcugbnvehrsqrelguitixiwqynqlozponlqwmbsdqdwqemovhgzkecderlnxqbrvbvoqudfosrzdlmtlzpholzfknhvjfvqusznlixtxhzbyvkokvyrszgrshsqpoqywiopehpzpdsccrinemcfsfwbprkyoxnflsduszhkbznekfleetnwohevlnzufqrwxpjfztemptchurxbtlztbneqpoefjygotuztyu Tag: Spam and this newsgroup! Tag: 182711
Current Issues Article Archive
A growing archive of fascinating media articles on current issues & affairs.
Available at Arcis Foundation Website:
www.arcis.co.uk/php/
--
Posted by News Bulk Poster
Unregistered version Tag: Spam and this newsgroup! Tag: 182709
WS - Dataset
Hi,
converting Dataset returned from Web service into cursor i get MEMO field
instaed of string.
Can i correct this?
Thanks,
Shalva Tag: Spam and this newsgroup! Tag: 182707
Printer emulations to correct paper tray
I'd like to be able to specify which paper tray on a laser
printer to send the print job to. How is this done? Is
it related to SET PRINTER TO with more code?
Thanks much! Tag: Spam and this newsgroup! Tag: 182701
Formatting dates in FRX report.
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C38FF3.DA63E2F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I take this date "10/10/2003" and format to this "10-Oct-2003?"
Thanks for the help.
John
------=_NextPart_000_000C_01C38FF3.DA63E2F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>How can I take this date "10/10/2003" =
and format=20
to this "10-Oct-2003?"</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks for the help.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>John</FONT></DIV></BODY></HTML>
------=_NextPart_000_000C_01C38FF3.DA63E2F0-- Tag: Spam and this newsgroup! Tag: 182693
How to change Path of the Base Classes ?
Unfortunateley have almost completed a project with Base Classes - Though
their Name is Same - from an other Folder instead of from the Project
Folder.
Need your help to change the path of the Class Library from the existing
Paths to some other Path for the Form Classes along with all the Controls on
it ?
Tanveer H. Malik
Cell: +923334227099 Tag: Spam and this newsgroup! Tag: 182681
Sorting by a specific column in Outlook from VFP
Hello, does any one how to sort on a specific column (i.e.
Subject, from, to etc) from VFP.
Thank you Tag: Spam and this newsgroup! Tag: 182680
Contemplating the unnatural
I am considering something so unusual that I feel bound to solicit other
opinions. I am building a webapp which will (hopefully) have many different
clients. Instead of, as usual, have a client id column as a key field in most
tables I'm thinking of a Windows folder named after the client id (which may be
numeric or alpha).
My reason for doing so is that, if a table becomes corrupted or I need to pack
tables, doing so will only affect one client at a time rather than all. This is
especially important because the system will need to be available all the time
(although, for each client, there might be a "no service" time, typically at the
client's local midnight time.
tia
regards - anthony shipley
look, ma - no .sig Tag: Spam and this newsgroup! Tag: 182678
ADO and OLD DB driver for Fox Pro 8
I am trying to insert a record with a fields that is of a
DBTimeStamp type through VB 6 ADO interface using OLE DB
DRiver for Fox Pro 8. However, only the date part is
inserted and the time part is 00:00:00.
CODE:
=====================
cmd.CommandText = "INSERT INTO EXCHANGELIST
(PRODUCTID, EXCHVALUE, UNIT, SYNCDT) VALUES(?,?,?,?)"
cmd.CommandType = adCmdText
cmd.CommandTimeout = 60
param.Type = adDBTimeStamp
param.Direction = adParamInput
param.Value = eff_date_in
cmd.Parameters.Append param
cmd.Execute (records)
==================================
- eff_date_in os of a type date
Is there any way to insert a datetime value into the Fox
Pro database from VB6 ? Tag: Spam and this newsgroup! Tag: 182674
Using enter key on a text box
Is there a way to allow the user to press enter in a text box, have it not
exit the box, and record the crlf into the field? The field is a memo field
and part of a grid. I know the obvious thing to do is make it an editbox,
but then it only shows 'memo' and not the actual data of the field.
So, I guess I'm asking is if there is a way to allow enter keys with a text
box or if there is a way to use an edit box and have it display the contents
of the field?
Thanks for the help.
Boyd Tag: Spam and this newsgroup! Tag: 182673
Winsock error codes don't match documentation
I am using the winsock control in an application. The error event will fire
with an error number, but the error number (12 or 232) does not match the
documentation on the error codes. Is this something to do with numeric types
from winsock to foxpro? I have searched everywhere and I can't find anything
on why they would be different, I did find some issues to do with the
function declaration if it is being run from vb.
Any ideas? Tag: Spam and this newsgroup! Tag: 182672
picture viewer
Hi sly foxes
Just wondering if there is a jpg viewer which can zoom by
clicking and dragging on a section of the picture and
doesn't end up distorted or fuzzy.
Paint has the almost similar characteristics if you have a
picture of a map with numbers on it and you crop a certain
section of the map and then stretch that section, it ends
up distorted.
Ultimately just click and drag a section of map and it
zooms at that selected section.
If there is an activeX component which does this would be
xcellent but any advice would be appreciative.
Thanks in advance
Patrick
Running FP 7 and XP Tag: Spam and this newsgroup! Tag: 182670
Do VFP ver 7.xx or 8.xx have ODBC drivers?
I am trying to find the latest VFP ODBC driver. The
latest I have is ver 6.1xxxxx
Was there a ver 7 ODBC driver?
Was there a ver 8 ODBC driver?
Thanks in advance Tag: Spam and this newsgroup! Tag: 182665
VFPOLEDB - what is working?
Now I've found out that the maxrecords property doesn't work with VFPOLEDB.
Where can I find documentation on what is working/not working with VFPOLEDB? Tag: Spam and this newsgroup! Tag: 182663
Exception: c0000006
I ran into this the other day, and could not find much on it. I happens when
a timer fires, and the only thing of interest in the timer code is a
reccount() that might be occurring when a user is adding/editing a table.
Anyone have any info on this? I've not seen a c0000006 before, and I think
it's rather rare. Tag: Spam and this newsgroup! Tag: 182655
Automation Word 97 & Word 2000
I have been using the following code to open up and exiting file that
has been working OK when the user has Word 2000 on his computer. One
user is using Word 97 and although the code starts up Word 97 it comes
up with a blank gray screen and does not load the file. Is there a
different way to call Word 97 to open an existing file??
Thanks for any help.
Tony
BINGO = M.C_FILE_NUM+'.DOC' ** Name of file to open is in this
field
CD REPORTS
GOODAPP = .T.
ON ERROR GOODAPP = .F.
oWORD = GetObject("&BINGO")
IF GOODAPP = .T.
WITH oWORD
.WindowState = 1
.APPLICATION.VISIBLE = .T.
ENDWITH
ELSE
WAIT 'COULD NOT OPEN YOUR WORD APPLICATION' WINDOW
ENDIF
CD .. Tag: Spam and this newsgroup! Tag: 182649
Easy Question about variables
Hello, I am returning to Foxpro after a 3 year hiatus(and
even before that I only used it part of the time). Anyway
I have a question that should be really simple to answer,
I just can't figure it out.
How do I declare a variable that will stay in scope
through out the life of a form(ie I want to set it in the
init procedure and check it in other procedures like on a
button click and in the release procedure.
Please help! Using VFP7.0
Thanks
Brian Tag: Spam and this newsgroup! Tag: 182640
InstallShield Express (2)
I am creating the setup with InstallShield Express.
In "Configure the Target System\Registry" I didn't select
any of HKEY values.
The problem is :
1. when the user is logged-on as administrator the
installation
finished correctly and he can work with application as
administrator, BUT NOT as ordinary user. The Win2000 or
WinNT report a message :
"Cannot locate the Microsoft Visual FoxPro support
library"
2. if the user is logged-on as user, the installation
crashes
with message that setup could not write to registry
Q: what action in ISE have I done that the user run setup
as
administrator and all other folks will work with
application
TIA
Mitja Tag: Spam and this newsgroup! Tag: 182638
MSCal.ocx problem with XP
Is anyone else out there having problems with the MSCal.ocx control with
VFP6.0 (SP5), if you run a form with this control I get a "OLE exception
error: Exception code c0000005. OLE object may be corrupt..." at the point
where we try and set the year property.
Just in the GUI, right click on this control, calendar properties, get a OLE
error and booted out of VFP. Sounds like it really is corrupt, how do I get
a clean copy installed.
Thanks in advance Grant Tag: Spam and this newsgroup! Tag: 182629
Import from Excel
I need to import a file from excel (office 2000) to fpw26. Yes I know get
with the program and upgrade. However the user is unable to do so at this
time. The excel file is in a day; time; name format with day being Tuesday,
October 7 and time being 24 hour clock and name being last, first. Append
from type xls results in time as .833 not 20:00
Any suggestions would be appreciated as usual. Thanks! Tag: Spam and this newsgroup! Tag: 182627
Fatal Error: Exception Code=C0000005
My worry about the compatability VFP7 and NTSC Windows are raised now. My client runs the
application in Chinese Windows XP and in a certain time this Fatal Error dialog box
appears.
This Fatal Error makes me so headache for many years and I don't know why it often
appears in Windows NT or XP. I don't know whether it can be appeared in Chinese version
of Windows.
However, it has no such problem in Windows 95 and Windows 98. Can anyone help me how to
solve it? Tag: Spam and this newsgroup! Tag: 182625
Text field justification in FRX report
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
All,
Is there a way to "justify" a text field? I.e., justified left and =
right margins? The basic properties are left, right and center, but =
nothing for full justification.
Thanks
John.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Is there a way to "justify" a text =
field? =20
I.e., justified left and right margins? The basic properties are =
left,=20
right and center, but nothing for full justification.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>John.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0010_01C38E95.3B7E9A90-- Tag: Spam and this newsgroup! Tag: 182622
XP Search tool
Anybody having problems getting accurate searches with XP
when searching for text in *.prg, *.sct files?
Windows 2000 was very accurate - XP is lousy at same
searches of the same network folders. XP SP1 supposedly
fixed a couple of problems in the search tool, but I
already have SP1. Tag: Spam and this newsgroup! Tag: 182607
Max index key length
Hi,
I'm trying to map the contents of the Windows registry to a table, which
isn't a problem in itself thanks to Rick Strahl and his registry class. The
problem I get is looking up a value in the table, which contains the full
registry key and value, e.g.
HKLM\SYSTEM\CurrentControlSet\Services\Dhcp\ImagePath. If I read the VFP
help correctly, these values can go a long way over the max index key length
of 240 bytes. Is there a good way to optimise a seek here without too much
linear search overhead?
My aim is to map the registry, make a change within Device Manager, then map
again and compare the two tables, so I know what's changed and can switch
states programatically from then on.
Alternately, does anyone know how to enable/disable all the USB ports on a
(remote) computer programatically?
Thanks
---
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 Tag: Spam and this newsgroup! Tag: 182606
VFP8 and .NET? What is a good resource for bringing myself up to speed?
I've been using foxpro for years, but I'm very unclear on what .NET can do
for me. Does anyone know of good books, websites, or articles that would be
helpful?
Thx,
Dan Tallent Tag: Spam and this newsgroup! Tag: 182604