Foxite.COM Visual FoxPro Forum

Databases, Tables and SQL Server: Cross Table

Thu, 23 May 2013 13:02:18 +0100

Version: Visual FoxPro 9 SP2

I have a vfp Cursor as under

cItem		nBlack   nBlue  nRed  nGreen  nOther

Anex Gel Pen     500      500    100     0       0
Rotomac BP	7000     6500   1500     0     200
Gliter  GP       400     1000    150    25      25    
Reynold GP      1000      750     50    10      10

(Here cItem c(35), nBlack n(7) , nBlue n(7), nRed n(7) , nGreen n(7), nOther n(7))

I need Result in a cursor as

cItem      	nQnty   cColor

Anex Gel Pen     500      BLK
Anex Gel Pen     500      BLU
Anex Gel Pen     100      RED
Rotomac BP	7000      BLK
Rotomac BP	6500      BLU
Rotomac BP	1000      RED
Rotomac BP	 200      ORS
Gliter  GP       400      BLK
Gliter  GP      1000      BLU
Gliter  GP       150      RED
Gliter  GP        25      GRE
Gliter  GP        25      ORS

Please Help

*Exchange of $1 Create only $1, But Exchage of one Ideas Makes different two Ideas*

Other: Need more clarification

Thu, 23 May 2013 05:51:38 +0100

Version: Visual FoxPro 9 SP2

Hi expert,

I want to ask if what is the use of m.(m dot)?

Thanks,
VFP Beginner

Foxite: feedback: Text file to Excel in foxpro 2.6

Thu, 23 May 2013 16:28:25 +0100

Version: FoxPro 2.x for MSDOS

Dear Experts,

I want convert text file to excel file
within foxpro 2.6 for DOS

Emp-ID Emp-Name Bank-Acc # Amount

1034 BUSHRA NAZ 00437900286703 11817
1037 SYED MINHAJ UDDIN 7900122603 5534

when i open this text in excel 2003 some employee bank account not show properly

Emp-ID Emp-Name Bank-Acc # Amount
1034 BUSHRA NAZ 4.379E+11 11817
1037 SYED MINHAJ UDDIN 7900122603 5534

how to solve this problem
for convert i used this command
type abc.txt to file abc.xls

thank you in advanced
Nadir

Web Services: Currency

Thu, 23 May 2013 08:41:43 +0100

Version: Visual FoxPro 9

Dear Sir,

I have following link

http://www.forex.pk/open_market_rates.asp

As shown in picture, I want to get US Dollar rate.

How is it possible with VFP codes?

Databases, Tables and SQL Server: SQL 2005 multi language support

Thu, 23 May 2013 15:46:50 +0100

Version: Visual FoxPro 8

Dear Experts,

I planning to make my sql server 2005 as multi language support.
But, After i inserting data,
except English language data is showing unreadable format like
this '???? ???????????????????'.
can anybody help me to how to solve this issue.

Regards
Abdulla

Databases, Tables and SQL Server: how to grant acces to local user to SQL

Thu, 23 May 2013 12:44:49 +0100

Version: Visual FoxPro 8

Dear Expert,

I have installed Sql server 2005, with Windows Authentication.
My problem is, I am not bale to connect using local user and domain user name.
(Note : This local user is a part of Admin Group).

But, I can connet and I can browse the database when i login as
Administrator.

Can anybody help me how to grant acces to local user to connect databse.

Regards
Abdulla

Reports and Printers: Shared printers vs APRINTERS()

Wed, 22 May 2013 19:11:54 +0100

Version: Visual FoxPro 9

Hello Comrades,

AFSIK, the APRINTERS() function, being OS specific, informs on installed printers. I am trying to decide on whether I should encourage users to setup sharing properties for their installed printers and then provide textboxes where they will enter the shared name for each type of report, like this for example:

Invoice printer
_______________________
|_______________________| TextBox

Labels printer
_______________________
|_______________________| TextBox

Reports
________________________
|________________________|

Is there an API I can use to validate these textbox values to check for the existance of a shared printer?

Regards

Patrick

p.s - sorry for the bad drawing; had some issues attaching a real screen shot.

Classes and Objects: how to identify any control across app

Tue, 21 May 2013 17:36:21 +0100

Version: Visual FoxPro 9 SP2

I want to find a way to identify any controls(VFP natice control, such as LABEL) located on all forms across my app, and the app has over 100 scx forms. I need to refer to any particular control during the app execution later, thus, the identity for each control should be permanent (not changed) once establed.
Please help.
Nilson

Classes and Objects: FoxCharts updates

Tue, 21 May 2013 05:00:36 +0100

Version: Visual FoxPro 9 SP2

Alex Yudin, a great collaborator of FoxCharts is working hard in adding new features to FoxCharts:
https://vfpx.codeplex.com/releases/view/106904

New features:
Introduced new Bar Types: Cone, Conoid, Pyramid and truncated pyramid (Frustum).
Right-clicking on the SideLegends in the chart, can call a new form that allows you to interactively apply changes to the way the side legends appear. You can change the Legend positions, colors, and other character formatting.
New gauge chart class

New properties:
- "GradientShapeDirection" - Numeric, determines the Gradient Brush direction (0-3).
- "GradientVertCount" and "GradientHorCount" - Numeric, determines the Shape Gradient Brush stripes count (vertical and horizontal)

Fixes:
Fix in "System.app". The distributed version avoids some bugs due to LOCAL variables declarations inside TRY/CATCH. May work faster in local net.

IMPORTANT:
Since this new version brings several modifications, the new and current Beta version is a subclass of the original and latest FoxCharts version v1.37. The new class is at the "Sources" folder, named "FoxChartsBeta.vcx".

All new samples, the ones that will benefit from the newest features will be stored in the "SamplesBeta" folder

Start playing with the form "ChartsSample_ArrowsInLegend.scx".
- Change the spinner values to see the new charts available
- Click on the Side Legends, to see cool stripes
- Right-click the over the SideLegends to call the new SideLegends form, and play with the new possibilities!

At the pictures below you can see some of the new features that are being developed:

new Cone shapes, and lines from legends (only when you click the legend)

new SideLegend configuration form
Notice the new gauge chart in action!

Download link:
https://vfpx.codeplex.com/releases/view/106904

Regards,

m.Cesar
My Blog

Active X Controls & OLE Automation: Reg-Free Com (Craig Boyd Projecthook)

Wed, 22 May 2013 09:38:37 +0100

Version: Visual FoxPro 9 SP2

Hi,

I am using Craig Boyd's projecthook class to generate a manifest for my application.
The program works when the activex is registered. However, when I run the application with
the activex unregistered I get Class Definition is not found.

Below is the manifest generated by Craig Boyd's projecthook class:

<?xml version="1.0" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
	<assemblyIdentity version="1.0.0.0" type="win32" name="Myapp.exe" processorArchitecture="x86"/>
	<description>Myapp</description>
	<dependency>
		<dependentAssembly>
			<assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" language="*" processorArchitecture="x86" publicKeyToken="6595b64144ccf1df"/>
		</dependentAssembly>
	</dependency>
	<trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
		<security>
			<requestedPrivileges>
				<requestedExecutionLevel level="highestAvailable" uiAccess="false"/>
			</requestedPrivileges>
		</security>
	</trustInfo>
  <file name="BIN\chilkatftp2.dll">
		<comClass description="ChilkatFtp2 Class" clsid="{302124C4-30A0-484A-9C7A-B51D5BA5306B}" progid="CHILKATFTP2Lib.ChilkatFtp2" threadingModel="Both"/>
  </file>
  <file name="BIN\chilkathttp.dll">
		<comClass description="ChilkatHttp Class" clsid="{39E861BD-E606-4733-8C79-FADDFD61DC8A}" progid="CHILKATHTTPLib.ChilkatHttp" threadingModel="Both"/>
    <comClass description="ChilkatHttpRequest Class" clsid="{B973393F-27C7-4781-877D-8626AAEDF119}" progid="CHILKATHTTPLib.ChilkatHttpRequest" threadingModel="Both"/>
    <comClass description="ChilkatHttpResponse Class" clsid="{E92B8334-177E-436F-9B42-9AD8511D909F}" progid="CHILKATHTTPLib.ChilkatHttpResponse" threadingModel="Both"/>
    <comClass description="ChilkatCache Class" clsid="{046DEE54-8711-4301-89EE-77AF626DB085}" progid="CHILKATHTTPLib.ChilkatCache" threadingModel="Both"/>
  </file>
  <file name="BIN\chilkatssh.dll">
		<comClass description="ChilkatSsh Class" clsid="{72A1C13F-1C23-4C52-97F0-BCA902148720}" progid="CHILKATSSHLib.ChilkatSsh" threadingModel="Both"/>
    <comClass description="ChilkatSshKey Class" clsid="{73111D94-E28A-4587-B687-60E23CD989A8}" progid="CHILKATSSHLib.ChilkatSshKey" threadingModel="Both"/>
    <comClass description="ChilkatSFtp Class" clsid="{64A17FBB-89E2-403F-8E06-B7CE412FB0E6}" progid="CHILKATSSHLib.ChilkatSFtp" threadingModel="Both"/>
    <comClass description="ChilkatSFtpFile Class" clsid="{B2208BCC-AB0F-4722-A908-2F54269D21C2}" progid="CHILKATSSHLib.ChilkatSFtpFile" threadingModel="Both"/>
    <comClass description="ChilkatSFtpDir Class" clsid="{39B10683-ED49-47A3-A4A5-AB1F52D1C2CC}" progid="CHILKATSSHLib.ChilkatSFtpDir" threadingModel="Both"/>
    <comClass description="ChilkatSshTunnel Class" clsid="{4D881197-5686-45BF-B9D9-9EC432F4BB75}" progid="CHILKATSSHLib.ChilkatSshTunnel" threadingModel="Both"/>
  </file>
  <file name="BIN\chilkatxml.dll">
		<comClass description="Chilkat XML" clsid="{CE2E4226-494A-4DB2-9B45-7C8586CC01A3}" progid="CHILKATXMLLib.ChilkatXml" threadingModel="Both"/>
    <comClass description="ChilkatRss Class" clsid="{CBD0BFC4-DD3E-4684-AD47-F80ADF9E006F}" progid="CHILKATXMLLib.ChilkatRss" threadingModel="Both"/>
    <comClass description="ChilkatAtom Class" clsid="{BA9D833B-FB8C-4F71-8E9E-50D0933C59D2}" progid="CHILKATXMLLib.ChilkatAtom" threadingModel="Both"/>
  </file>
</assembly>

The activex files are under the BIN folder within the application folder

Any hint or help will be appreciated.
Thx.
Noker Lodia

Forms: Email String

Thu, 23 May 2013 08:50:38 +0100

Version: Visual FoxPro 9

Sir,

I have following email address

abc@hotmail.com
xyz123@yahoo.com
eric@yahoo.com.uk

How to extract follwong parts

hotmail
yahoo
yahoo

Off-topic: xanthelasma Treatement

Mon, 20 May 2013 17:07:21 +0100

Version: Not Applicable

Hi Folks

What is the best home remedy for xanthelasma.
Any clue, great help

thanks
Subhankar
If you judge people, you have no time to love them.-Mother Teresa

Databases, Tables and SQL Server: Sql Query for Accounts

Mon, 20 May 2013 07:44:43 +0100

Version: Visual FoxPro 9 SP2

Dear Expert
I need vfp Sql calculated query for the attached tables and data,


sd = CTOD( "5/10/2013" )      && start date of transactions
ed = CTOD( "5/18/2013" )  && as the end date...
cBcode="00004"            && Bank Code  

Desired Result Should be
OpBal=500              &&Bank.Opbal+Query.opbal
CurrentBal=7500

if we changed the ending date to "ed = CTOD( "5/20/2013" )" the current balance should 57500.00.

http://www.foxite.com/uploads/07d31450-0160-4960-ac22-aa128e83914b.rar

thanks
Ali Khan

Grids: Click on Grid Header

Tue, 21 May 2013 16:17:13 +0100

Version: Visual FoxPro 9 SP2

Hi,

Is there anyway to click on Grid Header for indexing if it is generate through program. I am using the following code:

 Select sodisp
   Set Order To socode
   Go Top
   DoDefault()

   With Thisform.contmaster.grid1
      Set Filter To In sodisp
      Go Top
      .Width  = 907
      .Height = 352
      .Top    = 244
      .Left   = 19 && Adjust Grid position
      .ColumnCount = 9
      .HeaderHeight = 29
      .ReadOnly = .T.
      .FontName = "Tahoma"
      .RecordSource = "SoDisp"
      .RecordSourceType = 1
      .RowHeight = 27
      .DeleteMark = .F.
      *.setall("dynamicbackcolor", "IIF(RECNO()%2 = 0,RGB(219,125,27), RGB(255,255,255))", "Column")
      .Visible = .T.  && Grid control visible
      .ScrollBars = 2
      .column1.header1.Caption = 'ItemCode'
      .column2.header1.Caption = 'BarCode'
      .column3.header1.Caption = 'Item Description'
      .column4.header1.Caption = 'Cartons'
      .column1.ControlSource = "soDisp.Icode"
      .column2.ControlSource = "soDisp.BarCode"
      .column3.ControlSource = "soDisp.full_desc"
      .column4.ControlSource = "soDisp.QntyMaj"
      .column5.ControlSource = "soDisp.QntyMin"
      .column6.ControlSource = "soDisp.RateMaj"
      .column7.ControlSource = "soDisp.RateMin"
      .column8.ControlSource = "iif(soDisp.ratemin#0,soDisp.Unit,'Ctn.')"
      .column9.ControlSource = "iif(soDisp.qntymin*soDisp.ratemin#0,soDisp.qntymin*soDisp.ratemin,soDisp.qntymaj*soDisp.ratemaj)"
   Endwith

Saifuddin

Databases, Tables and SQL Server: alphanumeric password

Wed, 22 May 2013 15:18:09 +0100

Version: Visual FoxPro 6

Dear expert,

1. A program in a text box to check if the entry is alpha numeric.

If not the program should generate a message informing the user

that the entry is not complete.

2. The alpha numeric characters entered should have a length of
between 6-11.

A program to check the length.

Thanks

Forms: strange font behaviour

Wed, 22 May 2013 10:43:44 +0100

Version: Visual FoxPro 9 SP2

Hello all,

The main form of my app contains a lot of labels.
To adjust the label font to the (changing) size of the form I use following code in the INIT:

this.fontsize = int(this.fontsize*vhigh)

Vhigh = 0.75

Most of times , there is no problem, but sometimes, when a child form is closed, the font in the labels of the main form is set to BOLD or SMALL!

Any explication?

Regards

Paul Vandewalle

Databases, Tables and SQL Server: session time out -automatic log out

Wed, 22 May 2013 14:57:39 +0100

Version: Visual FoxPro 6

Dear Expert

Please provide the codes which will enable me achieve the following.

If an application is running and there is no activity say after

3 minutes, the system should automatically logout or the user need to re-identify

him or her self to the system before she will be allowed to continue.

Forms: Memo to Sql

Tue, 21 May 2013 22:27:42 +0100

Version: Visual FoxPro 9

Hello Experts

if i use LONGBLOB in mysql
when convert to vfp table it's convert to general field

if i want memo field in vfp, then what filed type use in mysql

thanks in advance

edited

Text Field in Mysql which Memo in VFP

Classes and Objects: Syntax Error & Class Browser

Tue, 21 May 2013 21:48:19 +0100

Version: Visual FoxPro 9 SP2

Hi Everybody:

I am using the class browser to get the code of a form. I am copying the code to a new prg file.
Then I want to run it. But an error appear in the following section:

ADD OBJECT form1.grid2.column1.header1 AS header WITH ;
FontName = "Arial", ;
FontSize = 8, ;
Alignment = 2, ;
Caption = "MyCaption", ;
ForeColor = RGB(0,0,128), ;
Name = "Header1"

Why the class browser can not produce the necessary code of the form, in this case, a header of the Grid?

Thanks

Databases, Tables and SQL Server: .Null. value

Tue, 21 May 2013 13:40:56 +0100

Version: Visual FoxPro 9

Hello experts

if some table field value as .Null.

is refer as a empty

my field Qty is .Null.

if ask like this

?empty(Qty)

is show result .f.

why

Errors & Debugging: Find characters starting from right

Tue, 21 May 2013 21:22:22 +0100

Version: Visual FoxPro 9

Hi All,

Pardon me if I got this thread in the wrong category. Users store images in various drives and folders. These images have names like imgFile1, imgFile2, imgFile3...to imgFile24 and change automatically on certain dates. I am trying to make this happen by retrieving the file name from its location, attach a new image file and store it back to its location.

this is my code

store table.cLocation to cImglocation
For i = 9 To 1 Step -1 && loop backwards from end to start to strip file for image name w/out it location (9 would be the longest image name - imgFile24)

If Substr(cImglocation,i-1,1) = '\' && if we see backslash, we have gone past the start of image name
Exit && so we exit
else
lcFile1 = Substr(cimglocation,i,i) && we keep storing chrs until full file name
endi
Endfor

the code above is failing and never gets to 1. the loop exits when i = 11 so I don't have a file name to continue with.

lcFile2=spac(0)
c=0
store val(substr(lcFile1,8,2)) to c
c=c+1
if c >= 10
Store Str(c,2) To cStr
else
Store Str(c,1) To cStr
endi

lcFile2 = substr(lcFile1,1,7)+cStr+".bmp" && now we have a file with a new name

Regards

Patrick

Reports and Printers: report with data from multiple records

Tue, 21 May 2013 10:26:50 +0100

Version: Visual FoxPro 9 SP2

Hi,

I'm wondering if it is possible to create a report with fields from different records from the same table.
The table has a fixed limited number of records (due to legislation).

In a report I would like to create for example 10 lines, with on each line a field value of a particular record, like:

"blablabla... value a = " --> show: record(1), field(a)
"blablabla... value b = " --> show: record(2), field(b)
"blablabla... value c = " --> show: record(8), field(c)
etc..

I can of course create the report using variables showing the above values, but is there an alternative way?

Regards, Gerrit

User Groups & Online Communities: Can't connect to Weblogs.Foxite.com

Tue, 21 May 2013 19:01:04 +0100

Version: Visual FoxPro 9 SP2

For some reason I'm unable to connect to the Weblogs.Foxite.com
Is anyone else experiencing this problem?

VFP and .NET: Excel sheet to visual foxpro table

Mon, 20 May 2013 17:39:08 +0100

Version: Visual FoxPro 9

Hi everyone. I just want to import some excel sheets to visual foxpro tables I really would appreciate your help.

B.Sanon

Databases, Tables and SQL Server: First Charecter Of Word

Tue, 21 May 2013 18:38:12 +0100

Version: Visual FoxPro 9

Hello Experts

how can i retrieve first character of the word

eg. my word is

MY FIRST JOB IN TOWN

now i want result like this

MFJIT

thanks in advance

VFP and .NET: Check Box

Tue, 21 May 2013 11:40:11 +0100

Version: Visual FoxPro 9

I am getting this problem while creating a FORM.
I have created a GRID with single column. Depending upon the data I keep adding
columns to GRID and assign the newly added column to the field (Numeric (1)).
I have made CHECKBOX control for that column. However, when I run the form
I am unable to change CHECKBOX value by clicking it.

Also, if somebody could help me, how do I manage functions of the controls
added in the GRID above.

Forms: connecting grid to form

Tue, 21 May 2013 08:08:04 +0100

Version: Visual FoxPro 9

hi
i'm sorry, iam a newbie :-)

i want to ask
how to connecting datagrid from other form to input the textbox another form
like this archive file
thanks a lot for your attention...
:-O
http://www.foxite.com/uploads/764d15b1-829e-4328-bf20-4086f114db8f.rar

General VFP Topics: define window

Mon, 20 May 2013 22:38:15 +0100

Version: Visual FoxPro 9 SP2

I am using the following statement to define a window.

DEFINE WINDOW win_disp FROM 02,05 TO 35,75 TITLE 'External COBROKE'

In rare cases, the information I want to display in the window exceeds the length of the window and causes the system to error.

Is there a way to define the window with a vertical scroll bar allowing me to display information beyond the length of the window?

I think I can define the window length longer then the screen. Only thing is, the user can not see the information beyond what the screen allows the user to see.

Win32API programming: SENDING SMS MESSAGES TO CELL PHONES

Mon, 20 May 2013 12:20:57 +0100

Version: Visual FoxPro 9

hello experts

i have a program on which i want to send sms or text to mobile handsets....
what procedures would be best for me to follow....

thank you

blessed bless

Databases, Tables and SQL Server: report in C Sharp with graph tutorials

Mon, 20 May 2013 08:03:42 +0100

Version: Not Applicable

Dear expert,

I want a tutorial in C Sharp both windows / web which will do the following:

1. A sample report with a grouping.

2. In addition the report should incorporate a graph

I've examined a number but they don't have it like we do it in vfp.

Please assist

Thanks

VFP and .NET: Grid Column1 searching

Mon, 20 May 2013 08:41:40 +0100

Version: Visual FoxPro 9

Hi expert
i build a form with Grid only comlumn1 with this grid
now i want to search a textbox in grid text column1
how can add search option with grid a textbox

Sandeep Singh (Ludhiana)

Databases, Tables and SQL Server: generate an executable in C Sharp

Mon, 20 May 2013 08:13:10 +0100

Version: Not Applicable

Dear experts,

How do you generate an executable for deployment for the windows environment and for the Web application.

The database is ms sql server 2008 and above

A sample with the necessary documentation or references will be more than welcomed.

Thanks

Errors & Debugging: Shellexecute problem !!!

Mon, 20 May 2013 05:24:56 +0100

Version: Visual FoxPro 9 SP2

Sir,

Thanks for your time, effort & help.

I need help.

If I run the following program, repeatedly, it generates error : "access denied".

I suspect, Shellexecute is throwing that error.
How to solve this ?

Thanks.
ramesh

SET SAFE OFF
SET CONF OFF
CLOS DATA ALL
ERASE PHONE.XLS

USE PHONE
DELETE FOR NAME = SPACE(25)
PACK
IF RECC() = 0
CLOSE DATA
CLEAR
RETURN
ENDIF

COPY TO PHONE.XLS TYPE XLS
CLOSE DATA ALL

DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, STRING cAction, STRING cFileName, ;
STRING cParams, STRING cDir, INTEGER nShowWin

cFileName = "phone.xls"
cAction = "open"
ShellExecute(0,cAction,cFileName,"","",1)

CLOSE ALL
CLEAR
RETURN