RE: Display a Google map on a form
Hi Christof I would very much appreciate the full sample code. Many thanks. In the meantime I have come up with this which works well enough Lparameters tcPostCode Local lcPostcode, lcHTML1, lcHTML2, lcHTML3, lcHTML, lcFile Thisform.Caption = tcPostcode lcPostcode = Strtran(tcPostcode, , +) lcHTML1 = [iframe width=425 height=350 frameborder=0 scrolling=no marginheight=0 marginwidth=0 src=http://maps.google.co.uk/maps?q=] lcHTML2 = [amp;hnear=] lcHTML3 = [,+United+Kingdomamp;z=14amp;iwloc=amp;output=embed/iframebr /] lcHTML = lcHTML1 + lcPostcode + lcHTML2 + lcPostcode + lcHTML3 = StrToFile(lcHTML, C:\test.html) cURL = file:///C:/test.html Thisform.olecontrol1.Navigate2(cURL) Paul Newton -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Christof Wollenhaupt Sent: 29 November 2012 16:42 To: profoxt...@leafe.com Subject: Re: Display a Google map on a form The following code uses the Google API to retrieve a map as a picture and display it on a form in a VFP image control named map. This code is from a method and uses a few helper classes. As Dave mentioned, the Google Maps API has a EULA that you would need to review. I can send you the full sample code, if you want. * * Retrieve and display map * *-- * Create helper objects *-- Local loHttp, loEncode loHttp = NewObject(cHttpClient, cHttpClient.prg) loEncode = NewObject(cHttpEncoding, cHttpClient.prg) *-- * Assemble Url. *-- Local lcUrl, lcWhat lcWhat = Alltrim(This.Value) If Empty(m.lcWhat) Return EndIf lcUrl = http://maps.googleapis.com/maps/api/staticmap; ; +?center=+loEncode.UrlEncode(m.lcWhat) ; +zoom=14 ; +size=+Transform(Thisform.map.Width) ; +x+Transform(Thisform.map.Height) ; +maptype=roadmap ; +sensor=false *-- * Retrieve and assign image *-- Local lcImg If m.loHttp.Connect(maps.googleapis.com) lcImg = loHttp.Get(m.lcUrl) Thisform.lblCode.Caption = m.loHttp.cStatusCode If not Empty(m.lcImg) and not IsNull(m.lcImg) Thisform.map.PictureVal = m.lcImg EndIf EndIf This.Value = Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/9a8106afb0ef9b44b69045c4448935a20dd...@ukfawexmbx1.infor.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Recommendations...
On Thu, Nov 29, 2012 at 10:31 PM, Paul McNett p...@ulmcnett.com wrote: If it was for Janie Secretary, then why does the task scheduler report errors with numeric codes? -- It protects their brand(s). Otherwise it would present: Foxpro f'ed up again. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmykcr7oyfj1g7n3nraf7nhhysptwjsgge1hl-at7xfd...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP to SQL Server View
Something like: m.lcConnectionString = server=sageserver;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=APAC m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString,.T.) 2nd parameter as .T., as the single-connection-per user, shared by remote views *!*SQLSETPROP(0,DispLogin,lnDispLogin) IF m.lnHandle 0 lcMessage2 = A connection handle could not be established to the server specified in the GFLClaims.INI file. WriteLog(m.lcLogFile, m.lcMEssage2 + : + m.lcConnectionString) *!*MESSAGEBOX(m.lcMEssage2 + CHR(13) + CHR(10) + m.lcConnectionString, 16, GFL Claims) llSuccess = .F. ENDIF llSuccess = SQLEXEC(m.lnHandle,SELECT field list FROM M2M_Booker WHERE where clause, c_MyLocalCursor)0 IF NOT m.llSuccess SQLDISCONNECT(m.lnHandle) lcMessage2 = Unable to connect to the server using the specified connection WriteLog(m.lcLogFile, m.lcMEssage2) llSuccess = .F. ENDIF Frank. Frank Cazabon On 30/11/2012 10:26 AM, Adam Buckland wrote: Ok totally new to this so hopefully someone has done this before... I have a view on SQL Server 2008 (It's a Sage accounts database if that matters) which I need to get at from foxpro 6 and later V9 The view spans 8 tables and basically gets invoicing details that I need to make a consolidated invoice to end up in a SAP system but to start with... is there a way to get data from this view completely under Foxpro to a local foxpro database without having to download individual tables and reconstruct the view? The database is called APAC on a server called sageserver and the view is dbo.M2M_BOOKER and is as follows: SELECTTOP (100) PERCENT dbo.SLCustomerAccount.CustomerAccountNumber, dbo.SLCustomerAccount.CustomerAccountName, dbo.SOPInvCredAddress.PostalName, dbo.SOPInvCredAddress.AddressLine1, dbo.SOPInvCredAddress.AddressLine2, dbo.SOPInvCredAddress.AddressLine3, dbo.SOPInvCredAddress.AddressLine4, dbo.SOPInvCredAddress.City, dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country, dbo.SOPInvCredAddress.PostCode, dbo.SOPInvoiceCredit.DocumentNo AS [Invoice Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2, dbo.SOPInvoiceCredit.DocumentDate, dbo.SOPInvoiceCreditLine.PrintSequenceNumber, dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity, dbo.SOPOrderReturnLine.ItemCode, dbo.SOPInvoiceCreditLine.ItemName, dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code, dbo.StockItem.Name, dbo.StockItem.Description, dbo.SOPDocDelAddress.Description AS DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME, dbo.SOPDocDelAddress.AddressLine1 AS DELADDRESS1, dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2, dbo.SOPDocDelAddress.AddressLine3 AS DELADDRESS3, dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4, dbo.SOPDocDelAddress.County AS DELADDRESSCOUNTY, dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY, dbo.SOPDocDelAddress.PostCode AS DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity, dbo.SOPOrderReturnLine.LineTotalValue, dbo.SOPOrderReturnLine.LineTaxValue, dbo.SOPOrderReturnLine.UnitSellingPrice, dbo.SOPOrderReturnLine.SellingUnitMultiple, dbo.SOPOrderReturnLine.PricingUnitMultiple FROMdbo.SOPOrderReturn INNER JOIN dbo.SOPInvoiceCreditLine ON dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPInvoiceCreditLine.SOPOrderReturnID INNER JOIN dbo.SOPInvoiceCredit ON dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID = dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN dbo.SLCustomerAccount ON dbo.SOPInvoiceCredit.CustomerID = dbo.SLCustomerAccount.SLCustomerAccountID INNER JOIN dbo.SOPOrderReturnLine ON dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPOrderReturnLine.SOPOrderReturnID AND dbo.SOPInvoiceCreditLine.SOPOrderReturnLineID = dbo.SOPOrderReturnLine.SOPOrderReturnLineID INNER JOIN dbo.StockItem ON dbo.SOPOrderReturnLine.ItemCode = dbo.StockItem.Code INNER JOIN dbo.SOPInvCredAddress ON dbo.SOPInvoiceCredit.SOPInvoiceCreditID = dbo.SOPInvCredAddress.SOPInvoiceCreditID INNER JOIN dbo.SOPDocDelAddress ON dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPDocDelAddress.SOPOrderReturnID WHERE(dbo.SLCustomerAccount.SLCustomerAccountID = 18598) ORDER BY [Invoice Number], dbo.SOPInvoiceCreditLine.PrintSequenceNumber --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting
RE: VFP to SQL Server View
Hi Steve Because we have to send the customer a consolidated invoice, a branch breakdown and an xls spreadsheet so I do it in foxpro and then email it across to them automatically. They then get it into SAP. Adam -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 30 November 2012 14:35 To: ProFox Email List Subject: Re: VFP to SQL Server View On Fri, Nov 30, 2012 at 8:26 AM, Adam Buckland adam.buckl...@eurohill.comwrote: ew on SQL Server 2008 (It's a Sage accounts database if that matters) which I need to get at from foxpro 6 and later V9 The view spans 8 tables and basically gets invoicing details that I need to make a consolidated invoice to end up in a SAP system but to start with... is there a way to get data from this view completely under Foxpro to a local foxpro database without having to download individual tables and reconstruct the view? -- Yeah you just use the view. Select * from M2M_BOOKER You can add a where clause as well. select * from M2M_BOOKER where CustomerAccountNumber = lcCustomerAccountNumber If you are loading SAP why would you do this in Foxpro? Either from SQLServer itself, or using SAP you should be able to put the same construction together for a data load to SAP. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/442E79C1A7355C4EA228D320AA59D69CD0F2FF@SBS2011.eurohill.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP to SQL Server View
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments to my now
renamed view dbo.BOOKER it falls over on the select MYTABLE with alias MYTABLE
not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I need to
make a consolidated invoice to end up in a SAP system but to start with... is
there a way to get data from this view completely under Foxpro to a local
foxpro database without having to download individual tables and reconstruct
the view?
The database is called APAC on a server called sageserver and the view is
dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName, dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2, dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice Number],
dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity, dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code, dbo.StockItem.Name,
dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS DELADDRESSDESC,
dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS DELADDRESSCOUNTY,
dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS DELADDRESSPOSTCODE,
dbo.SOPOrderReturnLine.LineQuantity, dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
dbo.SOPOrderReturnLine.PricingUnitMultiple
FROMdbo.SOPOrderReturn INNER JOIN
dbo.SOPInvoiceCreditLine ON
dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPInvoiceCreditLine.SOPOrderReturnID
INNER JOIN
dbo.SOPInvoiceCredit ON
dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID =
dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN
dbo.SLCustomerAccount ON
dbo.SOPInvoiceCredit.CustomerID = dbo.SLCustomerAccount.SLCustomerAccountID
INNER JOIN
dbo.SOPOrderReturnLine ON
dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPOrderReturnLine.SOPOrderReturnID
AND
dbo.SOPInvoiceCreditLine.SOPOrderReturnLineID =
dbo.SOPOrderReturnLine.SOPOrderReturnLineID INNER JOIN
dbo.StockItem ON dbo.SOPOrderReturnLine.ItemCode =
dbo.StockItem.Code INNER JOIN
dbo.SOPInvCredAddress ON
dbo.SOPInvoiceCredit.SOPInvoiceCreditID =
dbo.SOPInvCredAddress.SOPInvoiceCreditID INNER JOIN
dbo.SOPDocDelAddress ON
dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPDocDelAddress.SOPOrderReturnID
WHERE(dbo.SLCustomerAccount.SLCustomerAccountID = 18598)
ORDER BY [Invoice Number], dbo.SOPInvoiceCreditLine.PrintSequenceNumber
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
Re: [NF] [Mac Again] Localhost gone with the wind
OK, localhost is working now. Thanks so very much to all who pitched in. Of course when I upgraded Apple also deleted my PHP directory and with it my configuration file. grumble One thing I did not think to back up. On Thu, Nov 29, 2012 at 4:55 PM, Ken Kixmoeller (ProFox) foxh...@information-architecture.com wrote: The files that are failing are in the PHP tree. I am hoping that reinstalling PHP will fix it. On Thu, Nov 29, 2012 at 4:42 PM, lelandj lela...@mail.smvfp.com wrote: On 11/29/2012 02:02 PM, Ken Kixmoeller (ProFox) wrote: Include/private/etc/apache2/**other/*.conf The above command is telling httpd.conf to look in the /private/etc/apache2/other directory, and include all files with a .conf extension during httpd start, just as if they were embedded in the httpd.conf file itself. Perhaps this is where you should put your personal name.conf file. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- __**_ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/**listinfo/profoxhttp://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/** listinfo/profoxtech http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/**search/profoxhttp://leafe.com/archives/search/profox This message: http://leafe.com/archives/**byMID/profox/50B7E4DD.9090308@* *mail.smvfp.comhttp://leafe.com/archives/byMID/profox/50b7e4dd.9090...@mail.smvfp.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=L=us6uAhPf8S6-xRv1XZxvAihcwDBRhfo-B7Q=wzmy...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] [Mac Again] Localhost gone with the wind
On Wed, Nov 28, 2012, at 07:36 PM, Ken Kixmoeller (ProFox) wrote: (Apple must be learning from M$ how to break everything on upgrades.) Not much in that line happens in Windows these days. You need to look at Ubuntu or something for that sort of shenanigans. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1354294897.3893.140661160222773.50545...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments to my
now renamed view dbo.BOOKER it falls over on the select MYTABLE with alias
MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I need
to make a consolidated invoice to end up in a SAP system but to start
with... is there a way to get data from this view completely under Foxpro
to a local foxpro database without having to download individual tables and
reconstruct the view?
The database is called APAC on a server called sageserver and the view is
dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName, dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2, dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS DELADDRESSCOUNTY,
dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS
DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity,
dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
dbo.SOPOrderReturnLine.PricingUnitMultiple
FROMdbo.SOPOrderReturn INNER JOIN
dbo.SOPInvoiceCreditLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPInvoiceCreditLine.SOPOrderReturnID INNER JOIN
dbo.SOPInvoiceCredit ON
dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID =
dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN
dbo.SLCustomerAccount ON
dbo.SOPInvoiceCredit.CustomerID = dbo.SLCustomerAccount.SLCustomerAccountID
INNER JOIN
dbo.SOPOrderReturnLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPOrderReturnLine.SOPOrderReturnID AND
dbo.SOPInvoiceCreditLine.SOPOrderReturnLineID =
dbo.SOPOrderReturnLine.SOPOrderReturnLineID INNER JOIN
dbo.StockItem ON dbo.SOPOrderReturnLine.ItemCode
= dbo.StockItem.Code INNER JOIN
dbo.SOPInvCredAddress ON
dbo.SOPInvoiceCredit.SOPInvoiceCreditID =
dbo.SOPInvCredAddress.SOPInvoiceCreditID INNER JOIN
dbo.SOPDocDelAddress ON
dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPDocDelAddress.SOPOrderReturnID
WHERE(dbo.SLCustomerAccount.SLCustomerAccountID = 18598)
ORDER BY [Invoice Number], dbo.SOPInvoiceCreditLine.PrintSequenceNumber
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive
RE: VFP to SQL Server View
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how do I
reference a view in SQL Server is there a magic secret or isn't it possible?
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) = SQLEXEC(connHandle,
sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments
to my now renamed view dbo.BOOKER it falls over on the select MYTABLE
with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I
need to make a consolidated invoice to end up in a SAP system but to
start with... is there a way to get data from this view completely
under Foxpro to a local foxpro database without having to download
individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the view
is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName, dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS
DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS
DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS
DELADDRESSCOUNTY, dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS
DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity,
dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
dbo.SOPOrderReturnLine.PricingUnitMultiple
FROMdbo.SOPOrderReturn INNER JOIN
dbo.SOPInvoiceCreditLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPInvoiceCreditLine.SOPOrderReturnID INNER JOIN
dbo.SOPInvoiceCredit ON
dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID =
dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN
dbo.SLCustomerAccount ON
dbo.SOPInvoiceCredit.CustomerID =
dbo.SLCustomerAccount.SLCustomerAccountID
INNER JOIN
dbo.SOPOrderReturnLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPOrderReturnLine.SOPOrderReturnID AND
dbo.SOPInvoiceCreditLine.SOPOrderReturnLineID
= dbo.SOPOrderReturnLine.SOPOrderReturnLineID INNER JOIN
dbo.StockItem ON
dbo.SOPOrderReturnLine.ItemCode = dbo.StockItem.Code INNER JOIN
dbo.SOPInvCredAddress ON
dbo.SOPInvoiceCredit.SOPInvoiceCreditID =
dbo.SOPInvCredAddress.SOPInvoiceCreditID INNER
Re: VFP to SQL Server View
Try this:
lnSuccess = SQLEXEC(connHandle, sql8, 'MYTABLE')
IF m.lnSuccess = 0
AERROR(laError)
MESSAGEBOX(laError[3]))
ENDIF
Frank.
Frank Cazabon
On 30/11/2012 01:02 PM, Fred Taylor wrote:
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments to my
now renamed view dbo.BOOKER it falls over on the select MYTABLE with alias
MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I need
to make a consolidated invoice to end up in a SAP system but to start
with... is there a way to get data from this view completely under Foxpro
to a local foxpro database without having to download individual tables and
reconstruct the view?
The database is called APAC on a server called sageserver and the view is
dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName, dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2, dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS DELADDRESSCOUNTY,
dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS
DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity,
dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
dbo.SOPOrderReturnLine.PricingUnitMultiple
FROMdbo.SOPOrderReturn INNER JOIN
dbo.SOPInvoiceCreditLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPInvoiceCreditLine.SOPOrderReturnID INNER JOIN
dbo.SOPInvoiceCredit ON
dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID =
dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN
dbo.SLCustomerAccount ON
dbo.SOPInvoiceCredit.CustomerID = dbo.SLCustomerAccount.SLCustomerAccountID
INNER JOIN
dbo.SOPOrderReturnLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPOrderReturnLine.SOPOrderReturnID AND
dbo.SOPInvoiceCreditLine.SOPOrderReturnLineID =
dbo.SOPOrderReturnLine.SOPOrderReturnLineID INNER JOIN
dbo.StockItem ON dbo.SOPOrderReturnLine.ItemCode
= dbo.StockItem.Code INNER JOIN
dbo.SOPInvCredAddress ON
dbo.SOPInvoiceCredit.SOPInvoiceCreditID =
dbo.SOPInvCredAddress.SOPInvoiceCreditID INNER JOIN
dbo.SOPDocDelAddress ON
dbo.SOPOrderReturn.SOPOrderReturnID = dbo.SOPDocDelAddress.SOPOrderReturnID
WHERE(dbo.SLCustomerAccount.SLCustomerAccountID = 18598)
ORDER BY [Invoice Number],
Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how do I
reference a view in SQL Server is there a magic secret or isn't it possible?
SQL will either return rows or not. This is a case of NOT.
From inside SQL Server Management Studio can you select * from yourView?
and have it return records?
If so then your connection into the server is not pointing to the database
that holds your view. WAG here but it is pointing to master instead. :)
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) = SQLEXEC(connHandle,
sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments
to my now renamed view dbo.BOOKER it falls over on the select MYTABLE
with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I
need to make a consolidated invoice to end up in a SAP system but to
start with... is there a way to get data from this view completely
under Foxpro to a local foxpro database without having to download
individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the view
is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName,
dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS
DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS
DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS
DELADDRESSCOUNTY, dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS
DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity,
dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
dbo.SOPOrderReturnLine.PricingUnitMultiple
FROMdbo.SOPOrderReturn INNER JOIN
dbo.SOPInvoiceCreditLine ON
dbo.SOPOrderReturn.SOPOrderReturnID =
dbo.SOPInvoiceCreditLine.SOPOrderReturnID INNER JOIN
dbo.SOPInvoiceCredit ON
dbo.SOPInvoiceCreditLine.SOPInvoiceCreditID =
dbo.SOPInvoiceCredit.SOPInvoiceCreditID INNER JOIN
dbo.SLCustomerAccount ON
dbo.SOPInvoiceCredit.CustomerID =
dbo.SLCustomerAccount.SLCustomerAccountID
INNER JOIN
RE: VFP to SQL Server View
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and individually I
can access the tables from the SQL console
From FoxPro, I can access tables no problem but not a view... same code , put
in a table name rather than a view and bingo... change it to the view name and
nope
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: 30 November 2012 17:29
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how
do I reference a view in SQL Server is there a magic secret or isn't it
possible?
SQL will either return rows or not. This is a case of NOT.
From inside SQL Server Management Studio can you select * from yourView?
and have it return records?
If so then your connection into the server is not pointing to the database that
holds your view. WAG here but it is pointing to master instead. :)
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred
Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) =
SQLEXEC(connHandle, sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments
to my now renamed view dbo.BOOKER it falls over on the select
MYTABLE with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I
need to make a consolidated invoice to end up in a SAP system but to
start with... is there a way to get data from this view completely
under Foxpro to a local foxpro database without having to download
individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the
view is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName,
dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS
DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS
DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
dbo.SOPDocDelAddress.County AS
DELADDRESSCOUNTY, dbo.SOPDocDelAddress.Country AS DELADDRESSCOUNTRY,
dbo.SOPDocDelAddress.PostCode AS
DELADDRESSPOSTCODE, dbo.SOPOrderReturnLine.LineQuantity,
dbo.SOPOrderReturnLine.LineTotalValue,
dbo.SOPOrderReturnLine.LineTaxValue,
dbo.SOPOrderReturnLine.UnitSellingPrice,
dbo.SOPOrderReturnLine.SellingUnitMultiple,
Re: VFP to SQL Server View
Hi Adam,
Don't you need to be referencing dbo.M2M_Booker, not just dbo.Booker?
Brant
||
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments to my
now renamed view dbo.BOOKER it falls over on the select MYTABLE with alias
MYTABLE not found...
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/50b8edad.8050...@futureone.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP to SQL Server View
I renamed it just in case something silly with hyphens and underscores. try
and get it working as simply as possible then complicate it...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Brant E. Layton
Sent: 30 November 2012 17:32
To: profoxt...@leafe.com
Subject: Re: VFP to SQL Server View
Hi Adam,
Don't you need to be referencing dbo.M2M_Booker, not just dbo.Booker?
Brant
||
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments
to my now renamed view dbo.BOOKER it falls over on the select MYTABLE
with alias MYTABLE not found...
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/442E79C1A7355C4EA228D320AA59D69CD0F700@SBS2011.eurohill.local
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:32 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and
individually I can access the tables from the SQL console
Great
You can preface the db name in the table in your select statement.
select * from myDataBase.dbo.M2M_BOOKER
This will get data across any databases.
Now what is the USER you are connecting with? Does that USER have rights
to myDataBase? That may also be getting in the way.
HTH
From FoxPro, I can access tables no problem but not a view... same code ,
put in a table name rather than a view and bingo... change it to the view
name and nope
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: 30 November 2012 17:29
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how
do I reference a view in SQL Server is there a magic secret or isn't it
possible?
SQL will either return rows or not. This is a case of NOT.
From inside SQL Server Management Studio can you select * from yourView?
and have it return records?
If so then your connection into the server is not pointing to the database
that holds your view. WAG here but it is pointing to master instead. :)
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred
Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) =
SQLEXEC(connHandle, sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments
to my now renamed view dbo.BOOKER it falls over on the select
MYTABLE with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that I
need to make a consolidated invoice to end up in a SAP system but to
start with... is there a way to get data from this view completely
under Foxpro to a local foxpro database without having to download
individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the
view is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName,
dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS [Invoice
Number], dbo.SOPInvoiceCredit.SecondReference AS Refrence2,
dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
dbo.SOPDocDelAddress.Description AS
DELADDRESSDESC, dbo.SOPDocDelAddress.PostalName AS
DELADDRESSPOSTALNAME,
dbo.SOPDocDelAddress.AddressLine1 AS
DELADDRESS1,
dbo.SOPDocDelAddress.AddressLine2 AS DELADDRESS2,
dbo.SOPDocDelAddress.AddressLine3 AS
DELADDRESS3,
dbo.SOPDocDelAddress.AddressLine4 AS DELADDRESS4,
RE: VFP to SQL Server View
Adding the database name did it... Stephen you're a star.
Don't know why it worked as the view is in the right db area.. but it
does.. cheers...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: 30 November 2012 17:42
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:32 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and
individually I can access the tables from the SQL console
Great
You can preface the db name in the table in your select statement.
select * from myDataBase.dbo.M2M_BOOKER
This will get data across any databases.
Now what is the USER you are connecting with? Does that USER have rights to
myDataBase? That may also be getting in the way.
HTH
From FoxPro, I can access tables no problem but not a view... same
code ,
put in a table name rather than a view and bingo... change it to the
view name and nope
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: 30 November 2012 17:29
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how
do I reference a view in SQL Server is there a magic secret or isn't
it
possible?
SQL will either return rows or not. This is a case of NOT.
From inside SQL Server Management Studio can you select * from yourView?
and have it return records?
If so then your connection into the server is not pointing to the
database that holds your view. WAG here but it is pointing to master
instead. :)
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred
Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) =
SQLEXEC(connHandle, sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the
comments to my now renamed view dbo.BOOKER it falls over on the
select MYTABLE with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that
I need to make a consolidated invoice to end up in a SAP system
but to start with... is there a way to get data from this view
completely under Foxpro to a local foxpro database without having
to download individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the
view is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName,
dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
dbo.SOPInvoiceCredit.DocumentNo AS
[Invoice Number], dbo.SOPInvoiceCredit.SecondReference AS
Refrence2, dbo.SOPInvoiceCredit.DocumentDate,
dbo.SOPInvoiceCreditLine.PrintSequenceNumber,
dbo.SOPInvoiceCreditLine.InvoiceCreditQuantity,
dbo.SOPOrderReturnLine.ItemCode,
dbo.SOPInvoiceCreditLine.ItemName,
dbo.SOPOrderReturnLine.ItemDescription, dbo.StockItem.Code,
dbo.StockItem.Name, dbo.StockItem.Description,
Re: VFP to SQL Server View
There's usually also an option where you can specify the default database as part of setting up a DSN or as part of your connectionstring. On Fri, Nov 30, 2012 at 12:48 PM, Adam Buckland adam.buckl...@eurohill.comwrote: Adding the database name did it... Stephen you're a star. Don't know why it worked as the view is in the right db area.. but it does.. cheers... -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4ui4pJad=45oysguzq-p1ukgdoutdknc8nq9zecq7q...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Adding the database name did it... Stephen you're a star.
Don't know why it worked as the view is in the right db area.. but it
does.. cheers...
-
If you track your user info I bet that the initial db for that user is
Master. So when they log in poof that is where they are.
Now your connection string should fix that. Go to connectionstrings.com to
see how to do that for a M$SSQ connection.
Glad I could help out.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: 30 November 2012 17:42
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:32 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and
individually I can access the tables from the SQL console
Great
You can preface the db name in the table in your select statement.
select * from myDataBase.dbo.M2M_BOOKER
This will get data across any databases.
Now what is the USER you are connecting with? Does that USER have rights
to myDataBase? That may also be getting in the way.
HTH
From FoxPro, I can access tables no problem but not a view... same
code ,
put in a table name rather than a view and bingo... change it to the
view name and nope
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: 30 November 2012 17:29
To: ProFox Email List
Subject: Re: VFP to SQL Server View
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how
do I reference a view in SQL Server is there a magic secret or isn't
it
possible?
SQL will either return rows or not. This is a case of NOT.
From inside SQL Server Management Studio can you select * from yourView?
and have it return records?
If so then your connection into the server is not pointing to the
database that holds your view. WAG here but it is pointing to master
instead. :)
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred
Taylor
Sent: 30 November 2012 17:02
To: ProFox Email List
Subject: Re: VFP to SQL Server View
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from dbo.SLCustomerAccount
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.) =
SQLEXEC(connHandle, sql8, 'MYTABLE') = SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the
comments to my now renamed view dbo.BOOKER it falls over on the
select MYTABLE with alias MYTABLE not found...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam
Buckland
Sent: 30 November 2012 14:27
To: ProFox Email List (profox@leafe.com)
Subject: VFP to SQL Server View
Ok totally new to this so hopefully someone has done this before...
I have a view on SQL Server 2008 (It's a Sage accounts database if
that
matters) which I need to get at from foxpro 6 and later V9
The view spans 8 tables and basically gets invoicing details that
I need to make a consolidated invoice to end up in a SAP system
but to start with... is there a way to get data from this view
completely under Foxpro to a local foxpro database without having
to download individual tables and reconstruct the view?
The database is called APAC on a server called sageserver and the
view is dbo.M2M_BOOKER and is as follows:
SELECTTOP (100) PERCENT
dbo.SLCustomerAccount.CustomerAccountNumber,
dbo.SLCustomerAccount.CustomerAccountName,
dbo.SOPInvCredAddress.PostalName,
dbo.SOPInvCredAddress.AddressLine1,
dbo.SOPInvCredAddress.AddressLine2,
dbo.SOPInvCredAddress.AddressLine3,
dbo.SOPInvCredAddress.AddressLine4,
dbo.SOPInvCredAddress.City,
dbo.SOPInvCredAddress.County, dbo.SOPInvCredAddress.Country,
dbo.SOPInvCredAddress.PostCode,
How to tell if file has changed (comparing network file to local copy)
In one of my apps, I'm putting in an option to copy some tables locally and query there instead of the network. This will not only increase performance (because this solution is a query-only solution...it's just for reporting) but will allow the user to query while disconnected from our network. Some of the tables involved do NOT have a timestamp field on them. For the ones that do, I can just query the NETWORK and LOCAL tables joined on primary keys where there's a difference in timestamp, but how do you suggest I do it for the tables where no timestamp field exists? For now, it's just one table and it's not large at all. (2500 records?) tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b911e3.30...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On Fri, Nov 30, 2012 at 12:06 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: snipped Some of the tables involved do NOT have a timestamp field on them. Are you wanting to compare the contents on a record by record basis, or just are they different? You said they are small, so how about FILETOSTR such as: f1 = filetostr(theLocalFile) f2 = filetostr(theNetworkFile) if f1 f2 etc -- Matt Jarvis Eugene, Oregon USA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capt54ryicxnx8ozryohbaubg2cxpjnomkxpefbsrz2yrtdb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On 11/30/2012 3:23 PM, M Jarvis wrote: On Fri, Nov 30, 2012 at 12:06 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: snipped Some of the tables involved do NOT have a timestamp field on them. Are you wanting to compare the contents on a record by record basis, or just are they different? You said they are small, so how about FILETOSTR such as: f1 = filetostr(theLocalFile) f2 = filetostr(theNetworkFile) if f1 f2 etc Seems like a hash of some sort would be the way to go versus filetostr() but perhaps not. OTOH, why not just compare the file's datetime stamp? If difference found though, I could just copy the file down (again). For the large files, I control them with timestamp fields, so I guess for those I would simply say grab everything beyond the MAX(LocalDBF) key value...since these records are just added to the pile and not edited. Hmmm...it's good to talk it out here! ;-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b917ef.3010...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On Nov 30, 2012, at 2:32 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Seems like a hash of some sort would be the way to go versus filetostr() but perhaps not. OTOH, why not just compare the file's datetime stamp? If difference found though, I could just copy the file down (again). For the large files, I control them with timestamp fields, so I guess for those I would simply say grab everything beyond the MAX(LocalDBF) key value...since these records are just added to the pile and not edited. Hmmm...it's good to talk it out here! ;-) If you want to know if the contents have changed, hashing is the way to go. If you want to check if it has been accessed, then the timestamps might be better, although those can be manipulated. Do you care if a file was changed and then reverted? -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/31171839-9460-413a-8af4-89d9fb07c...@rackspace.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
I think you're on the trail. MD5 is meant to be a fast hash, as opposed to slow hashing which should be used for salted passwords, such as BCrypt. On 11/30/2012 03:32 PM, MB Software Solutions, LLC wrote: On 11/30/2012 3:23 PM, M Jarvis wrote: On Fri, Nov 30, 2012 at 12:06 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: snipped Some of the tables involved do NOT have a timestamp field on them. Are you wanting to compare the contents on a record by record basis, or just are they different? You said they are small, so how about FILETOSTR such as: f1 = filetostr(theLocalFile) f2 = filetostr(theNetworkFile) if f1 f2 etc Seems like a hash of some sort would be the way to go versus filetostr() but perhaps not. OTOH, why not just compare the file's datetime stamp? If difference found though, I could just copy the file down (again). For the large files, I control them with timestamp fields, so I guess for those I would simply say grab everything beyond the MAX(LocalDBF) key value...since these records are just added to the pile and not edited. Hmmm...it's good to talk it out here! ;-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b91887.7020...@cullytechnologies.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: How to tell if file has changed (comparing network file to local copy)
MB Software Solutions, LLC wrote on 2012-11-30: In one of my apps, I'm putting in an option to copy some tables locally and query there instead of the network. This will not only increase performance (because this solution is a query-only solution...it's just for reporting) but will allow the user to query while disconnected from our network. Some of the tables involved do NOT have a timestamp field on them. For the ones that do, I can just query the NETWORK and LOCAL tables joined on primary keys where there's a difference in timestamp, but how do you suggest I do it for the tables where no timestamp field exists? For now, it's just one table and it's not large at all. (2500 records?) tia, --Mike Mike, If there isn't too many fields, and no Memo field. Union them together to screen noconsole. If the RECCOUNT() = _TALLY then they are the same. If you didn't do a file copy of the file to the local machine, the headers will have different time stamps. So Hashing and the DOS FC command will show differences. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/002501cdcf3b$5694b9e0$03be2da0$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On 11/30/2012 3:34 PM, Ed Leafe wrote: On Nov 30, 2012, at 2:32 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Seems like a hash of some sort would be the way to go versus filetostr() but perhaps not. OTOH, why not just compare the file's datetime stamp? If difference found though, I could just copy the file down (again). For the large files, I control them with timestamp fields, so I guess for those I would simply say grab everything beyond the MAX(LocalDBF) key value...since these records are just added to the pile and not edited. Hmmm...it's good to talk it out here! ;-) If you want to know if the contents have changed, hashing is the way to go. If you want to check if it has been accessed, then the timestamps might be better, although those can be manipulated. Do you care if a file was changed and then reverted? Hi Ed, The network file is just a source repository of records that only get added to as time goes on. There are never any edits...just new records added. Also, reverting should never happen in this instance. (Never say never!) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b91dca.9050...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On 11/30/2012 3:43 PM, Tracy Pearson wrote: If there isn't too many fields, and no Memo field. Union them together to screen noconsole. If the RECCOUNT() = _TALLY then they are the same. If you didn't do a file copy of the file to the local machine, the headers will have different time stamps. So Hashing and the DOS FC command will show differences. Thanks Tracy. I guess I'll check out Craig Boyd's HASH function in one of his .FLL files. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b91e4d.4000...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] [Mac Again] Permissions, was Localhost gone with the wind
I am also searching, but I thought Ed, Ted might give me another clue. Apache is running and reasonably-well configured, PHP is running, but as soon as it hits a reference to one of my script files, I get an error: No Permission to the containing directory. How do I give Apache permission to gain access to the directories containing my code? I tried chmod with full permissions and that did not help. Thanks, guys -- - - Ken --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=LnxB_dbMRd+6LNqBheY7Utspa3xnfEM=onhprb5sbm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] [Mac Again] Permissions, was Localhost gone with the wind
On Nov 30, 2012, at 3:12 PM, Ken Kixmoeller (ProFox) foxh...@information-architecture.com wrote: How do I give Apache permission to gain access to the directories containing my code? I tried chmod with full permissions and that did not help. You might need to use 'chown' to change the owner to the user that apache is running as. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/85a06d70-eb47-4ee8-9137-e17e2a16e...@rackspace.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know when they were last changed. On Fri, Nov 30, 2012 at 3:06 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: In one of my apps, I'm putting in an option to copy some tables locally and query there instead of the network. This will not only increase performance (because this solution is a query-only solution...it's just for reporting) but will allow the user to query while disconnected from our network. Some of the tables involved do NOT have a timestamp field on them. For the ones that do, I can just query the NETWORK and LOCAL tables joined on primary keys where there's a difference in timestamp, but how do you suggest I do it for the tables where no timestamp field exists? For now, it's just one table and it's not large at all. (2500 records?) -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4thendm+qnvjuvh-dp3soepqqlnwbmps706c4zxcu_...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Instant google street view site
Pretty Cool Stephen! For the heck of it - I plugged in meteor crater - and it went there pretty darned quick. I've been there myself on 2 occasions. For those that have never heard of it - check it out! -K- On 11/30/2012 3:05 PM, Stephen Russell wrote: http://www.qsview.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b92d95.1090...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] [Mac Again] Permissions, was Localhost gone with the wind
On Fri, Nov 30, 2012 at 3:25 PM, Ed Leafe ed.le...@rackspace.com wrote: You might need to use 'chown' to change the owner to the user that apache is running as. OK, I'll go to try to figure out that. I remember the configuration file saying the owner group I like a mystery, but I'd like this damn thing to work even more --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=lkyhqnglwwl4aocr9vifrsmrwe5mjjxvek0a6srwkz...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] [Mac Again] Permissions, was Localhost gone with the wind
OK, instead of chown, I changed the user and group of Apache in the configuration file. It worked! Hoop-de-do! Next step: I am going to have a beer. Maybe a nice IPA. Friday reward. Thanks again to all HAGW, everyone. Ken On Fri, Nov 30, 2012 at 4:22 PM, Ken Kixmoeller (ProFox) foxh...@information-architecture.com wrote: On Fri, Nov 30, 2012 at 3:25 PM, Ed Leafe ed.le...@rackspace.com wrote: You might need to use 'chown' to change the owner to the user that apache is running as. OK, I'll go to try to figure out that. I remember the configuration file saying the owner group I like a mystery, but I'd like this damn thing to work even more --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=Lm7vuDh_RjtUALc=gdqciozch1hj89vnqkutdwt-br...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Any Non-ActiveX solutions for SFTP in VFP?
Does anyone have any suggestions for implementing SFTP in vfp? Cheap/free preferred, but not required. I'll check again, but I'm pretty sure my goto for Internet, West-Wind, doesn't do SFTP. Not urgent, just would like to avoid active-x and stick to native VFP or open source if possible. Thanks. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b94f4f.9060...@taconic.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Any Non-ActiveX solutions for SFTP in VFP?
We use the PuTTY suite for ssh and scp, which is scriptable via a RUN command. http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html On Fri, Nov 30, 2012 at 7:29 PM, Vincent Teachout tea...@taconic.netwrote: Does anyone have any suggestions for implementing SFTP in vfp? Cheap/free preferred, but not required. I'll check again, but I'm pretty sure my goto for Internet, West-Wind, doesn't do SFTP. Not urgent, just would like to avoid active-x and stick to native VFP or open source if possible. Thanks. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4v7k9kJ-PKQtcXux=5-wznfrzobspbr3fh355roua+...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On 11/30/2012 4:30 PM, Ted Roche wrote: SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know when they were last changed. COOL! You're the expert on these things...is it using something in the Header of the DBF to know this or just the file system date/time? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b95e68.7010...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How to tell if file has changed (comparing network file to local copy)
On 11/30/2012 8:33 PM, MB Software Solutions, LLC wrote: On 11/30/2012 4:30 PM, Ted Roche wrote: SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know when they were last changed. COOL! You're the expert on these things...is it using something in the Header of the DBF to know this or just the file system date/time? After reading the VFP Help topic, it looks like it uses both. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b95ebc.40...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Any Non-ActiveX solutions for SFTP in VFP?
+1 Original Message Subject: Re: Any Non-ActiveX solutions for SFTP in VFP? From: Ted Roche tedro...@gmail.com To: profoxt...@leafe.com Date: 11/30/2012 6:39 PM We use the PuTTY suite for ssh and scp, which is scriptable via a RUN command. http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html On Fri, Nov 30, 2012 at 7:29 PM, Vincent Teachout tea...@taconic.netwrote: Does anyone have any suggestions for implementing SFTP in vfp? Cheap/free preferred, but not required. I'll check again, but I'm pretty sure my goto for Internet, West-Wind, doesn't do SFTP. Not urgent, just would like to avoid active-x and stick to native VFP or open source if possible. Thanks. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b98f25.3090...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[OT] Leland Bait
Hi Everybody, http://video.foxbusiness.com/v/1995183710001/check-out-new-volkswagen-beetle?intcmp=related There he goes, he's trading . . . -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50b9b47c.2020...@verizon.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
