Re: VFP and SQL expert needed for a few hours work

Why not show some class and reply back private to Wes. -- 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 --- ___

Re: VFP and SQL expert needed for a few hours work

Wes, I can do an evaluation of the existing system, proposed replacement and status off any work done to this point. - Michael Oke, II oke...@gmail.com 661-349-6221 Our business is defined by our commitment to our Customers. - On Feb 12, 2015 10:18 AM, "Wes Wilson" wrote: > We need som

Re: VFP and SQL expert needed for a few hours work

Y Op donderdag 12 februari 2015 heeft Vince Teachout het volgende geschreven: > On 2/12/2015 1:14 PM, Wes Wilson wrote: > >> We need someone who can evaluate an existing conversion that seems not >> to be going anywhere. $142,00 > > has been spent but it appears not much has been done. We w

Re: VFP and SQL expert needed for a few hours work

On 2/12/2015 1:14 PM, Wes Wilson wrote: We need someone who can evaluate an existing conversion that seems not to be going anywhere. $142,000 has been spent but it appears not much has been done. We will be taking over the work so one of our programmers could not be an impartial witness.

Re: VFP and SQL expert needed for a few hours work

Hi Wes, I can help on the conversion strategy Currently converting VFP apps to the Web and SQL database. Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 12/02/2015 19:14, Wes Wilson a écrit : We need someone who can evaluate an existing conv

RE: VFP and SQL expert needed for a few hours work

I'm available immediately AND I've done many of these. Most recent assessment was for the Attorney General of Texas in 2009 when myself and another fellow did a reverse engineering of their "case management" system in about 60 days (which was pretty fast considering it was pc based, and mainfra

Re: Vfp and sql

Exactly. On 23 January 2012 12:07, Dan Covill wrote: > On 01/23/12 06:50, Sytze de Boer wrote: >> It gives me the 1 record I want >> BUT >> I also need to combine the memodetails into this same single record Can this >> be done ? > > There's no way VFP can automatically concatenate those mem

Re: Vfp and sql

On 01/23/12 06:50, Sytze de Boer wrote: > It gives me the 1 record I want > BUT > I also need to combine the memodetails into this same single record Can this > be done ? There's no way VFP can automatically concatenate those memo fields for you (much less do anything with a Blob field). I'd su

RE: Vfp and sql

In theory, you could use a select to create the memodetails column in your newtable. Something like: select client,sum(invvalue) as invttl, desc, ordnum, (select memodetails from mytable where ...) as memodetails from mytable into table newtable group by client, ordnum But you don't have a f

Re: Vfp and sql

Make the cursor readwrite and stuff the detail memo contents in the one? Regards, Desmond Sent via BlackBerry by AT&T -Original Message- From: Sytze de Boer Sender: profox-boun...@leafe.com Date: Mon, 23 Jan 2012 15:43:19 To: profox Reply-To: ProFox Email List Subject: Vfp and sql I

Re: vfp and sql server stored procedures

On Fri, 14 Jan 2011 15:09 -0300, "Rafael Copquin" wrote: > You asked why I want to use an SP instead of simple VFP passthrough. The > answer is: I don't know. I just read somewhere that stored procedures > are "better" so, in my ignorance.. > In general there is plenty of debate as to th

Re: vfp and sql server stored procedures

On Fri, Jan 14, 2011 at 12:09 PM, Rafael Copquin wrote: > You asked why I want to use an SP instead of simple VFP passthrough. The > answer is: I don't know. I just read somewhere that stored procedures > are "better" so, in my ignorance.. > > As for updating or adding to the table, that could

Re: vfp and sql server stored procedures

You asked why I want to use an SP instead of simple VFP passthrough. The answer is: I don't know. I just read somewhere that stored procedures are "better" so, in my ignorance.. As for updating or adding to the table, that could be a possibility but then I would do that with a regular VFP s

Re: vfp and sql server stored procedures

On Fri, Jan 14, 2011 at 5:48 AM, Rafael Copquin wrote: > I want to write a SP in SQL Server, where I would send three parameters > and get one result, like so: > > 1st param      a table name > 2nd param    a field name in that table > 3rd param     a value > > I would like to concatenate all thre

Re: vfp and sql server stored procedures

On Fri, 14 Jan 2011 09:01 -0600, "Stephen Russell" wrote: > In your case for a dynamic generation I would say it is NOT better in an > SP. > > An SP is great for tested standard code that delivers expected > results. This is not that type of request. I would agree - using an SP is overcompli

Re: vfp and sql server stored procedures

On Fri, Jan 14, 2011 at 8:57 AM, Rafael Copquin wrote: > I just need to know whether or not the record exists, so a return of 0 > if it does not exist or 1 if it does is ok > > But I would rather go the SQL Stored procedures way (if it is better > than  the way suggested by Alan In y

Re: vfp and sql server stored procedures

On Fri, Jan 14, 2011 at 5:48 AM, Rafael Copquin wrote: > I want to write a SP in SQL Server, where I would send three parameters > and get one result, like so: > > 1st param      a table name > 2nd param    a field name in that table > 3rd param     a value > > I would like to concatenate all thre

Re: vfp and sql server stored procedures

I just need to know whether or not the record exists, so a return of 0 if it does not exist or 1 if it does is ok But I would rather go the SQL Stored procedures way (if it is better than the way suggested by Alan Rafael El 14/01/2011 11:39, Stephen Russell escribió: > On Fri, Jan 14, 2011 a

Re: vfp and sql server stored procedures

On Fri, Jan 14, 2011 at 6:22 AM, Alan Bourke wrote: > I don't think this needs to be an SQL Server sproc, it needs to just be > a VFP SQLEXEC() parameterised query. For example, assuming string fields > and an existing connection : > > lcSQL = "select count(" + fieldname + ") as c from " + tablena

Re: vfp and sql server stored procedures

I don't think this needs to be an SQL Server sproc, it needs to just be a VFP SQLEXEC() parameterised query. For example, assuming string fields and an existing connection : lcSQL = "select count(" + fieldname + ") as c from " + tablename + " where " + fieldname + "='" + value + "'" SqlExec(nHand

Re: vfp and sql server - import/export doc files

On Behalf >> Of Rafael Copquin >> Sent: 12 November 2010 12:58 >> To: profox@leafe.com >> Subject: Re: vfp and sql server - import/export doc files >> >> It looks like the message I sent went out truncated. >> >> Here's the original: >> >&g

Re: vfp and sql server - import/export doc files

> > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of > Rafael Copquin > Sent: 12 November 2010 15:45 > To: profox@leafe.com > Subject: Re: vfp and sql server - import/export doc files > > I know you posted

RE: vfp and sql server - import/export doc files

2010 15:45 To: profox@leafe.com Subject: Re: vfp and sql server - import/export doc files I know you posted them some time ago, however I could never get it to work properly. At the time I was just beginning with SQL Server and got lost in some of the intricacies of connections, permits, transac

Re: vfp and sql server - import/export doc files

On Behalf Of > Rafael Copquin > Sent: 12 November 2010 12:58 > To: profox@leafe.com > Subject: Re: vfp and sql server - import/export doc files > > It looks like the message I sent went out truncated. > > Here's the original: > > quote > > Some time ago I pos

RE: vfp and sql server - import/export doc files

ave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 12 November 2010 12:58 To: profox@leafe.com Subject: Re: vfp and sql server - import/export doc files It looks like the message I sent went out truncated. Here&

Re: vfp and sql server - import/export doc files

On Fri, Nov 12, 2010 at 7:19 AM, Rafael Copquin wrote: > That's what I'm doing now, but the requirement I have is to keep access > to the word files limited to only a few selected users. And it is very > easy for anybody to simply click on a word document and view it. So that > is why I thought of

Re: vfp and sql server - import/export doc files

That's what I'm doing now, but the requirement I have is to keep access to the word files limited to only a few selected users. And it is very easy for anybody to simply click on a word document and view it. So that is why I thought of saving the doc files into a SQL Server database and then re

Re: vfp and sql server - import/export doc files

If I was doing that I wouldn't touch a varbinary field, I'd store the documents externally and use a text field in the DB with a path to the relevant file. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Su

Re: vfp and sql server - import/export doc files

It looks like the message I sent went out truncated. Here's the original: quote Some time ago I posted a similar question but never got quite the answer I need, so here it goes again. I want to save a bunch of doc files into a SQL Server field I want to be able to retrieve those documents at wi

Re: vfp and sql server - import/export doc files

On Thu, Nov 11, 2010 at 4:27 PM, Rafael Copquin wrote: > > > > > > > > > > > > > > code should be to export > to retrieve - ? -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell ___ Post Messages to: ProF

Re: VFP and SQL (was Large Data Tables)

I use SQL Server Express 2008 in the Windows 2008 Server. Rafael Copquin Hi Rafael, profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin profoxt...@leafe.com www.connectionstrings.com. I have been the

Re: [spam] RE: VFP and SQL (was Large Data Tables)

Or you could just use a VPN and avoid the port forwarding from the router... but I know you said you wanted to avoid it. -Steve >You need to set up DNAT on the router, to forward incoming packets >on the SQL Server >port to the Server's address. Otherwise, there's no way to route to >the server

Re: [spam] RE: VFP and SQL (was Large Data Tables)

On 7/19/10 8:04 AM, Rafael Copquin wrote: > Thanks Dave > > I guess cServer_Name="192.168.1.1" below would have to be changed to the > HO server address. Now, is it the router address alone or a combination > of the router address and the Windows Server 2008 machine address? If > so, how do you wri

RE: VFP and SQL (was Large Data Tables)

Nice catch Richard, I totally missed that in my reply. -Steve At 11:39 AM 07/19/2010, you wrote: >Hi Rafael, > >You say the server is Windows 2008 but don't >specify the version of SQL installed. > >For testing purposes, can you create an ODBC >connection using the ODBC Administrator to >verif

RE: VFP and SQL (was Large Data Tables)

Hi Rafael, You say the server is Windows 2008 but don't specify the version of SQL installed. For testing purposes, can you create an ODBC connection using the ODBC Administrator to verify that you can connect to the server on the internal network? The first thing that pops out at me is that

Re: VFP and SQL (was Large Data Tables)

The only change would be the SERVER= section of your connection string. You would change that to the name of the remote sql server hosting the box. You may need to set some security settings on W2008, but since I don't have W2008 I can't assist with that. -Steve At 10:23 AM 07/19/2010, you w

RE: [spam] RE: VFP and SQL (was Large Data Tables)

nt to give a user administrative rights to everything! Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 19 July 2010 16:05 To: ProFox Email List Subject: Re: [spam] RE: VFP and SQL (was Large Data Tables) Thanks Da

Re: [spam] RE: VFP and SQL (was Large Data Tables)

Thanks Dave I guess cServer_Name="192.168.1.1" below would have to be changed to the HO server address. Now, is it the router address alone or a combination of the router address and the Windows Server 2008 machine address? If so, how do you write it? ie. router address = 192.168.1.1 server ad

RE: VFP and SQL (was Large Data Tables)

Rafael, This will work on SQL Server 2008 and if you make the cServer_Name "192.168.1.1\SQLEXPRESS" then it will work for SQL Express servers. cUser="sa" cPassword="sa" cServer_Name="192.168.0.1" cDB_Name="Data" && DBC Container Name Here cConnection_String="Driver={SQL Server};"

Re: [spam] RE: VFP and SQL Server + Word files

t;Word.doc" > > nReturn=Strtofile(cData, cTemp_Name) > > * Put a preview in a picture box on the > * form if it is a picture etc. > Thisform.imgImage.Picture=cTemp_Name > > Dave C > > -Original Message- > From: profox-boun...@leafe.com [mailto:profo

RE: VFP and SQL Server + Word files

nReturn=Strtofile(cData, cTemp_Name) * Put a preview in a picture box on the * form if it is a picture etc. Thisform.imgImage.Picture=cTemp_Name Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 03 June 2010 00:24

RE: VFP and SQL Server + Word files

010 7:24 PM To: profoxt...@leafe.com Subject: Re: VFP and SQL Server + Word files Wow Richard! This is precisely what I need! Since it is 8:30 PM here, I'll adapt your code to my form tomorrow morning and see how it goes. Thank you very much Rafa

Re: VFP and SQL Server + Word files

Wow Richard! This is precisely what I need! Since it is 8:30 PM here, I'll adapt your code to my form tomorrow morning and see how it goes. Thank you very much Rafael Copquin El 02/06/2010 19:49, Richard Kaye escribió: > For some reason, I got interested in this. Here's a little proof of co

RE: VFP and SQL Server + Word files

Rafael, Sorry I didn't include details on how to retrieve the data back. I'll let you know tomorrow as it's a little late now. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 02 June 2010 23:05 To: profoxt...@le

RE: VFP and SQL Server + Word files

For some reason, I got interested in this. Here's a little proof of concept. I swear it works on my system... If the list wraps it too much, let me know and I'll email the PRG to you. #DEFINE CRLF CHR(13)+CHR(10) ** * Program: SAVEDOCTOSQL1.PRG *

Re: VFP and SQL Server + Word files

Thaks Steve I'll try this Rafael El 02/06/2010 01:40 p.m., Stephen Russell escribió: > On Wed, Jun 2, 2010 at 11:35 AM, Richard Kaye wrote: > >> Does SQL 2008 Express support the ntext data type? That's a binary datatype >> and SQL won't try to do any character translation on a binary datat

Re: VFP and SQL Server + Word files

On Wed, Jun 2, 2010 at 11:35 AM, Richard Kaye wrote: > Does SQL 2008 Express support the ntext data type? That's a binary datatype > and SQL won't try to do any character translation on a binary datatype, iirc. > When you save the doc file to a memvar, it contains non-ascii values that you > ne

Re: VFP and SQL Server + Word files

-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Rafael Copquin > Sent: 02 June 2010 00:12 > To: ProFox Email List > Subject: Re: VFP and SQL Server + Word files > > Thank you, I'm looking forward to it, because I could not make it work. > > I used a very

RE: VFP and SQL Server + Word files

o: profoxt...@leafe.com Subject: Re: VFP and SQL Server + Word files Thank you, I'm looking forward to it, because I could not make it work. I used a very simple word doc (nothing fancy, just plain text, that is, a simple commercial letter). I did this: public cDoc cDoc = filetostr('c:\wo

Re: VFP and SQL Server + Word files

On Tue, Jun 1, 2010 at 6:13 PM, Rafael Copquin wrote: > Where is your .NET code, Steve? -- Here you go. There is a good explination to what is happening as needed here. -- Stephen Russell Sr. Production Systems Progr

RE: VFP and SQL Server + Word files

And I have nearly finished the classes and will post them soon, sorry for the delay. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 02 June 2010 00:12 To: ProFox Email List Subject: Re: VFP and SQL Server

RE: VFP and SQL Server + Word files

Oh, and the field in the SQL Database needs to be VarBinary(MAX)... Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 02 June 2010 00:12 To: ProFox Email List Subject: Re: VFP and SQL Server + Word files Thank

RE: VFP and SQL Server + Word files

es=?cBlob where .." SQLExec(nHandle, cCMD) Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 02 June 2010 00:12 To: ProFox Email List Subject: Re: VFP and SQL Server + Word files Thank you, I'm looking forward t

Re: VFP and SQL Server + Word files

On Tue, Jun 1, 2010 at 6:13 PM, Rafael Copquin wrote: > Where is your .NET code, Steve? Sorry. This isn't the one I had early this am. That is in the browser cache at work. pretty much same stuff, diff

Re: VFP and SQL Server + Word files

Where is your .NET code, Steve? Rafael El 01/06/2010 11:35, Stephen Russell escribió: > On Tue, Jun 1, 2010 at 9:26 AM, Dave Crozier wrote: > >> Ricardo& Rafael, >> I'm just cleaning up the classes for you at the moment and will let you know >> when I post the zip file in Ed's download sec

Re: VFP and SQL Server + Word files

t the moment and will let you know > when I post the zip file in Ed's download section. > > Dave C > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Ricardo Aráoz > Sent: 28 May 2010 20:28 > To: ProFox Ema

Re: VFP and SQL Server + Word files

On Tue, Jun 1, 2010 at 9:26 AM, Dave Crozier wrote: > Ricardo & Rafael, > I'm just cleaning up the classes for you at the moment and will let you know > when I post the zip file in Ed's download section. This is all .NET code / example but if you read the "what is happening" you

RE: VFP and SQL Server + Word files

May 2010 20:28 To: ProFox Email List Subject: Re: VFP and SQL Server + Word files Grigore Dolghin wrote: > You're right - that's the way it should be done. > > > Now compare this with "Insert Into DestinationTable (Select * From > SourceTable)". LOL Yes, you&#

Re: [spam] Re: vfp and sql function equivalence

Superb! Thank you Rafael El 28/05/2010 20:28, Fred Taylor escribió: > http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping > > Fred > > > On Fri, May 28, 2010 at 4:11 PM, Rafael Copquinwrote: > > >> Where can I find a list of VFP functions and their equivalent T-SQL >> functions? >> >> Pleas

RE: vfp and sql function equivalence

>> http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping<< Great resource. I think I hit this page several times a week. {g} Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com ___ Post Messages to: ProFox@

Re: vfp and sql function equivalence

http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping Fred On Fri, May 28, 2010 at 4:11 PM, Rafael Copquin wrote: > Where can I find a list of VFP functions and their equivalent T-SQL > functions? > > Please post a good URL to check. > > TIA and have a nice weekend > > Rafael Copquin > > > > ---

Re: [spam] RE: VFP and SQL Server + Word files

> > Dave C > > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Ricardo Aráoz > Sent: 28 May 2010 14:39 > To: ProFox Email List > Subject: Re: VFP and SQL Server + Word files > > Dave Crozier wrote

Re: VFP and SQL Server + Word files

Grigore Dolghin wrote: > You're right - that's the way it should be done. > > > Now compare this with "Insert Into DestinationTable (Select * From > SourceTable)". LOL Yes, you've got a point. OTOH all your inserts must concern themselves with getting a new ID versus a slight possibility of hav

Re: VFP and SQL Server + Word files

Hi, Tracy In SQL Server the Uniqueidentifier datatype is 16 bytes long. Opening the table in any sql server client would show the text representation, but the db actually stores the binary guid. On Fri, May 28, 2010 at 7:00 PM, Tracy Pearson wrote: > Stephen Russell wrote on 2010-05-28: >> On Fr

Re: VFP and SQL Server + Word files

You're right - that's the way it should be done. Now compare this with "Insert Into DestinationTable (Select * From SourceTable)". 2010/5/28 Ricardo Aráoz : > Grigore Dolghin wrote: >> I completely, wholehearted, 100% agree. GUID is the WAY to go - >> started using them as PKs back in 2004 I thi

Re: VFP and SQL Server + Word files

It is a uniqueidentifier and not string. Sent from my iPhone Stephen Russell 901.246-0159 On May 28, 2010, at 11:00 AM, "Tracy Pearson" wrote: > Stephen Russell wrote on 2010-05-28: >> On Fri, May 28, 2010 at 9:54 AM, Grigore Dolghin >> wrote: >>> I heard concers about speed of GUIDs versus

Re: VFP and SQL Server + Word files

Dave Crozier wrote: > Ricardo and Raphael and anyone else interested, > I am away over the weekend but I will post the code and an appropriate > message here on either Monday evening or Tuesday. > > Dave C > TIA ___ Post Messages to: ProFox@leafe.com

Re: VFP and SQL Server + Word files

Grigore Dolghin wrote: > I completely, wholehearted, 100% agree. GUID is the WAY to go - > started using them as PKs back in 2004 I think, when I was asked to > unify the databases of a program created by me and installed initially > in two different locations. 1 year later they came and said "well

RE: VFP and SQL Server + Word files

Stephen Russell wrote on 2010-05-28: > On Fri, May 28, 2010 at 9:54 AM, Grigore Dolghin > wrote: >> I heard concers about speed of GUIDs versus integers. While integers >> are indeed faster, the difference is not that big at all. > -- > GUID is not slower unless you are pullin

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 9:54 AM, Grigore Dolghin wrote: > I completely, wholehearted, 100% agree. GUID is the WAY to go - > started using them as PKs back in 2004 I think, when I was asked to > unify the databases of a program created by me and installed initially > in two different locations. 1 y

Re: VFP and SQL Server + Word files

I completely, wholehearted, 100% agree. GUID is the WAY to go - started using them as PKs back in 2004 I think, when I was asked to unify the databases of a program created by me and installed initially in two different locations. 1 year later they came and said "well, Grig, can you put them togeth

RE: VFP and SQL Server + Word files

Sent: 28 May 2010 14:39 To: ProFox Email List Subject: Re: VFP and SQL Server + Word files Dave Crozier wrote: > Raphael, > I have exactly the VFP coding that you need and you can hold any document > type, pictures, Word, Excel etc etc. If you want it I'll clean it up and > send

Re: VFP and SQL Server + Word files

By all means, send them to me!! Thank you very much indeed!! Rafael Copquin rcopq...@ciudad.com.ar El 28/05/2010 10:18 a.m., Dave Crozier escribió: > Raphael, > I have exactly the VFP coding that you need and you can hold any document > type, pictures, Word, Excel etc etc. If you want it I'll c

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 8:46 AM, Grigore Dolghin wrote: > In adition to Stephen's message - there is a function in SQL server > named SCOPE_IDENTITY() which returns the last ID inserted by you, even > if someone else already inserted records. > > Select Scope_Identity() As MyLastId > > I don't rem

Re: VFP and SQL Server + Word files

In adition to Stephen's message - there is a function in SQL server named SCOPE_IDENTITY() which returns the last ID inserted by you, even if someone else already inserted records. Select Scope_Identity() As MyLastId I don't remember exactly when it was introduced, I guess SQL Server 2005, but an

Re: VFP and SQL Server + Word files

Dave Crozier wrote: > Raphael, > I have exactly the VFP coding that you need and you can hold any document > type, pictures, Word, Excel etc etc. If you want it I'll clean it up and > send it to you. There are a few neat tricks you need to pull with VFP Data > to get it into the format for SQL Ser

RE: VFP and SQL Server + Word files

Correct Stevea brain fart from me there I'm afraid.. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 28 May 2010 14:22 To: ProFox Email List Subject: Re: VFP and SQL Server + Word files On Fri, M

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 8:18 AM, Dave Crozier wrote: > Raphael, > I have exactly the VFP coding that you need and you can hold any document > type, pictures, Word, Excel etc etc. If you want it I'll clean it up and > send it to you. There are a few neat tricks you need to pull with VFP Data > to g

RE: VFP and SQL Server + Word files

Raphael, I forgot to add, I use the classes in a bespoke document retrieval system we have here. Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 28 May 2010 13:32 To: ProFox Email List Subject: VFP and SQL Serve

RE: VFP and SQL Server + Word files

Raphael, I have exactly the VFP coding that you need and you can hold any document type, pictures, Word, Excel etc etc. If you want it I'll clean it up and send it to you. There are a few neat tricks you need to pull with VFP Data to get it into the format for SQL Server. I would use the newly "in

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 7:32 AM, Rafael Copquin wrote: > I have a requirement to save hundreds of Word files, with sensitive > information, so only the user can read them and prevent anybody from > copying them. > > I thought of saving them in a SQL Server database and this raises a few > question

RE: VFP and SQL Server + Word files

afe.com Subject: Re: VFP and SQL Server + Word files But I still need the "push code into VFP and out" Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free v

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 7:50 AM, Rafael Copquin wrote: > Thanks Steve, of all people I knew you would reply swiftly (:->) > > But I still need the "push code into VFP and out" I thought you already had a picker form that the user can find their file, an you just wanted to save it

Re: VFP and SQL Server + Word files

Thanks Steve, of all people I knew you would reply swiftly (:->) But I still need the "push code into VFP and out" Rafael Copquin El 28/05/2010 9:43, Stephen Russell escribió: > On Fri, May 28, 2010 at 7:32 AM, Rafael Copquin > wrote: > >> I have a requirement to save hundreds of Word fi

Re: VFP and SQL Server + Word files

On Fri, May 28, 2010 at 7:32 AM, Rafael Copquin wrote: > I have a requirement to save hundreds of Word files, with sensitive > information, so only the user can read them and prevent anybody from > copying them. > > I thought of saving them in a SQL Server database and this raises a few > question

RE: VFP and SQL Server : CursorAdapters

PM To: [EMAIL PROTECTED] Subject: RE: VFP and SQL Server : CursorAdapters On Friday, August 25, 2006 2:39 PM David Stevenson wrote: >Right, John. We could just repeat the entire day's schedule each evening in the bar (or around the porta-bar), huh? I'm thinking that about >midnight t

RE: VFP and SQL Server : CursorAdapters

On Friday, August 25, 2006 2:39 PM David Stevenson wrote: >Right, John. We could just repeat the entire day's schedule each evening in the bar (or around the porta-bar), huh? I'm thinking that about >midnight the sessions might get very interesting. Is that when the sheep show up? 8-) David L.

RE: VFP and SQL Server : CursorAdapters

Sounds good to me, Ed. I'm really looking forward to seeing and meeting everyone in Atlanta. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Thursday, August 24, 2006 7:07 PM To: [EMAIL PROTECTED] Subject: Re: VFP and SQL S

RE: VFP and SQL Server : CursorAdapters

ohn harvey Sent: Thursday, August 24, 2006 6:33 PM To: [EMAIL PROTECTED] Subject: RE: VFP and SQL Server : CursorAdapters If we miss a session, maybe we can get the presenter to give us a "dog and pony" show after hours John -Original Message- From: [EMAIL PROTECTED] [mailto:

RE: VFP and SQL Server : CursorAdapters

I went to the site and sent an email. See you there. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Thursday, August 24, 2006 9:46 PM To: 'ProFox Email List' Subject: RE: VFP and SQL Server : CursorAdapters j

RE: VFP and SQL Server : CursorAdapters

john harvey <> wrote: > I hadn't heard about it. Are you going? Yes. You should go. Stephen Russell DBA / Operations Developer Memphis TN 38115 901.246-0159 http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Vi

RE: VFP and SQL Server : CursorAdapters

I hadn't heard about it. Are you going? John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Thursday, August 24, 2006 9:09 PM To: 'ProFox Email List' Subject: RE: VFP and SQL Server : CursorAdapters john harvey &l

RE: VFP and SQL Server : CursorAdapters

john harvey <> wrote: > If we miss a session, maybe we can get the presenter to give us a > "dog and pony" show after hours Hey John are you going to the Memphis Code Camp this weekend? Hit the www.memphisdot.net site for more details. Stephen Russell DBA / Operations Developer Memphis TN 381

Re: VFP and SQL Server : CursorAdapters

On Aug 24, 2006, at 6:32 PM, David Stevenson wrote: Yeah, that's what I say! I might just skip out on the CursorAdapter session to listen to you talk about Dabo. Someone else can push the button to show my slides. :-) Tell you what: I'll be happy to blab about Dabo any time during the c

RE: VFP and SQL Server : CursorAdapters

If we miss a session, maybe we can get the presenter to give us a "dog and pony" show after hours John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Stevenson Sent: Thursday, August 24, 2006 5:32 PM To: profox@leafe.com Subject: RE: V

RE: VFP and SQL Server : CursorAdapters

Ed, Yeah, that's what I say! I might just skip out on the CursorAdapter session to listen to you talk about Dabo. Someone else can push the button to show my slides. :-) Dave Stevenson > http://foxforward.net/session.php?topic=23 >> Yeah, but that conflicts with

Re: VFP and SQL Server : CursorAdapters

On Aug 24, 2006, at 5:34 PM, Kevin Cully wrote: http://foxforward.net/session.php?topic=23 Yeah, but that conflicts with !! ;-) -- Ed Leafe -- http://leafe.com -- http://dabodev.com ___ P

Re: VFP and SQL Server : CursorAdapters

s one will show how to bring just a few records for your grid http://www.utmag.com/wconnect/wc.dll?9,7,10,2126 Regards Rafael Copquin www.copquin.com.ar Universal Thread Magazine - Translation Coordinator Treasurer - Microsoft Users Group of Argentina (MUG) www.mug.org.ar - Original

Re: VFP and SQL Server : CursorAdapters

http://foxforward.net/session.php?topic=23 There's still room for more! Kevin Cully CULLY Technologies, LLC Sponsor of Fox Forward 2006! http://foxforward.net Philip B wrote: Thanks Rafael and Andy for your comments. They are helpful in my project... Philip ___

Re: VFP and SQL Server : CursorAdapters

Regards Rafael Copquin www.copquin.com.ar Universal Thread Magazine - Translation Coordinator Treasurer - Microsoft Users Group of Argentina (MUG) www.mug.org.ar - Original Message - From: "Philip B" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 22,

  1   2   >