from:"Ajoy Khaund"

Re: Mobile App

2019-06-18 Thread Ajoy Khaund

Azure does have Virtual Machine. Let me have a look. Right now I don't have
any idea about VM.
Thanks a lot.
Since the inventory program days you have always shown me the right path.

On Tue, Jun 18, 2019 at 7:13 PM Stephen Russell 
wrote:

> SSRS reporting comes to mind but you will have to put up a VM that hosts
> the service, it is not a part of Azure I believe.
>
> SSRS is not as good as FP reporting when you first start using it because
> you don't know the tool yet.  SSRS is superior to VFP reporting because it
> doesn't bind any printer into the report.  You could also do the same thing
> with Power BI if you wanted.
>
>
> On Tue, Jun 18, 2019 at 7:25 AM Ajoy Khaund  wrote:
>
> > Hi All,
> >
> > Need some advice on the way forward.
> > I have been developing apps in Vfp6 & 9 for quite some time with a lot of
> > help from you all.
> > Last year I redid an application using Winforms and Azure Sql database.
> >
> > Now I want to develop a mobile app to view reports from the Azure Sql
> > database
> >
> > Mobile App will have say a login screen
> > then an option to select a report
> > a date option will be there and say a submit button
> > The report must display.
> >
> > No data entry in the phone as of now.
> >
> > Which way should I look? I am looking at Xamarin since I have Visual
> > Studio.
> > If anyone knows any better options please advice.
> >
> > Thanks a lot in advance.
> >
> > --
> > Regards,
> >
> > Ajoy Khaund
> > Neamati Road
> > Bhogdoi Mukh
> > Jorhat 785001
> > Assam, India
> >
> > Tel: 91-376-2351288
> > Cell: 91-94350-92287
> > Mail: akha...@hotmail.com
> > Mail: akha...@gmail.com
> > http://teaanalyst.blogspot.com/
> >
> >
> > "Walking on water and developing software from a specification are easy
> if
> > both are frozen."
> > - Edward  V. Berard, "Life-Cycle Approaches"
> >
> >
> > --- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAPs4RvW=p+ojcydgadmrpdvtq_pbuye7b_5gotmt98d4y5q...@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: Mobile App

2019-06-18 Thread Ajoy Khaund

Thanks
I am using the community edition.

On Tue, Jun 18, 2019 at 6:03 PM Alan Bourke  wrote:

> If you have a VS licence then Kamarin would be a good option.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
> On Tue, 18 Jun 2019, at 1:25 PM, Ajoy Khaund wrote:
> > Hi All,
> >
> > Need some advice on the way forward.
> > I have been developing apps in Vfp6 & 9 for quite some time with a lot of
> > help from you all.
> > Last year I redid an application using Winforms and Azure Sql database.
> >
> > Now I want to develop a mobile app to view reports from the Azure Sql
> > database
> >
> > Mobile App will have say a login screen
> > then an option to select a report
> > a date option will be there and say a submit button
> > The report must display.
> >
> > No data entry in the phone as of now.
> >
> > Which way should I look? I am looking at Xamarin since I have Visual
> Studio.
> > If anyone knows any better options please advice.
> >
> > Thanks a lot in advance.
> >
> > --
> > Regards,
> >
> > Ajoy Khaund
> > Neamati Road
> > Bhogdoi Mukh
> > Jorhat 785001
> > Assam, India
> >
> > Tel: 91-376-2351288
> > Cell: 91-94350-92287
> > Mail: akha...@hotmail.com
> > Mail: akha...@gmail.com
> > http://teaanalyst.blogspot.com/
> >
> >
> > "Walking on water and developing software from a specification are easy
> if
> > both are frozen."
> > - Edward  V. Berard, "Life-Cycle Approaches"
> >
> >
> > --- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/caps4rvwmjdew8wx++fhg4u9jwvadkjbx-0zz+mwap8bjrtu...@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.

Mobile App

2019-06-18 Thread Ajoy Khaund

Hi All,

Need some advice on the way forward.
I have been developing apps in Vfp6 & 9 for quite some time with a lot of
help from you all.
Last year I redid an application using Winforms and Azure Sql database.

Now I want to develop a mobile app to view reports from the Azure Sql
database

Mobile App will have say a login screen
then an option to select a report
a date option will be there and say a submit button
The report must display.

No data entry in the phone as of now.

Which way should I look? I am looking at Xamarin since I have Visual Studio.
If anyone knows any better options please advice.

Thanks a lot in advance.

-- 
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


"Walking on water and developing software from a specification are easy if
both are frozen."
- Edward  V. Berard, "Life-Cycle Approaches"


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAPs4RvUjMjqyc=ha1r1AhwnU1RX-W-DOL_gzJp0yC6qF7c=b...@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: Application User Level Access

2018-05-17 Thread Ajoy Khaund

Thanks.
I have reversed the order as of now.

1. Reports Only
2. Data Entry Only (NO Master Entry)
3. Manager (Data Entry + Master Entry)
4. Admin (All Forms & create users)

On Tue, May 15, 2018 at 10:45 PM, Charlie-gm <ccbible...@gmail.com> wrote:

> I'll apologize in advance some of this is somewhat basic, but I want to be
> clear about my approach.
>
> One thing that I do in VFP is to first subclass all the base classes into
> it's own .vcx. So I get something like "mybutton" which was subclassed from
> button.
>
> Now, in pretty much all those classes, I add  a property "naccess". I
> default the value to 1 (which can, of course, be overridden when I
> instantiate it on a form).
>
> In addition to that property I add another "lRemovebyAccess". I usually
> default this to .F.
>
> I also have a global object that has a property "userlevel" - when the
> application starts, that property gets set to some value (numeric) based on
> whatever rules are used for that application.
>
> Then, in the .Init() method of all my baseclasses I have the following
> code snippet:
> IF THIS.lRemovebyAccess == .T. AND THIS.nAccess > oApp.nUserLevel
> THIS.Visible = .F.
> THIS.Enabled = .F.
> ENDIF
>
> So now, whenever I put the buttons, grids, spinners, images, whatever...
> on a form, I can set the .lRemovebyAccess and nAccess of the objects.
>
> One thing to remember is if you put code in .Init's of your instantiated
> buttons (the ones you drop on a real form), you need to call DoDefault() in
> that code (of course).
>
> The lRemovebyAccess is a little redundant, but it gives a very quick way
> to make everything visible if you're having  problem debugging (e.g.
> .SetAll()). Also, it made it easy to completely swap the "security
> importance" of the app with just 1 baseclass property setting: that is,
> change the concept from specifically picking things to hide to specifically
> picking things to show.
>
> I would recommend at least 10 levels of access: I've rarely seen more than
> 5, but you just know...
>
> Also, I ran into a case where not only did they want tiered access levels,
> they also wanted to let one Admin see and do somethings and another Admin
> to see/do different things. I won't clutter up this already long email with
> that stuff but it essentially was just another property ".cfuncaccess" that
> could contain a string of characters. And then in the logon the user was
> assigned his "string" (usually a single character). From there the above
> IF statement was modified to include the check of strings, etc.
>
> I've put this in my generic visual class library that I use on all
> projects. A couple times about halfway into developing they said, '... oh
> yeah, we want to also add security levels' My prime contractor freaked
> out, told them it would add like a year to the project, yada yada. But
> after one meeting to be clear on requirements, I rolled it out in a week
> (which actually upset my prime contractor because they wanted to charge a
> lot more money... heh).
>
> -HTH
> -Charlie
>
> On 5/14/2018 1:29 AM, Ajoy Khaund wrote:
>
>> Hi All,
>>
>> In my applications I have added a user table where there will be field to
>> define the user level.
>>
>> Level - 1 Admin: can add users and has access to all
>> Level - 2 Manager - cannot add user but has access to all others
>> Level - 3 Operator - can add transactions but cannot create masters (eg.
>> add/edit a customer)
>>
>>
>
[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/caps4rvvwdlok2e2sn+ytkjwk+2kc8ud5x2hrfx4pyaonppn...@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: Application User Level Access

2018-05-14 Thread Ajoy Khaund

Thanks doing something similar. Ok I was thinking of a table with the list
of forms also but now my mind is free.

On Mon, May 14, 2018 at 8:01 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:

> If I had to guess, I'd say that there are thousands of different ways to
> handle this. In the past, I've used several different methods depending on
> my needs at the time. The simplest method of controlling access is to check
> whether someone has enough security to see a screen or not before you run
> the form such as:
>
> if vartype(glAdmin) = 'U'
> glAdmin = .t.
> endif
>
> if glAdmin
> do form sys_system with .t.
> else
> thisform.utilities.msgbox('You do not have Administrator Rights to
> this screen!','FATALERROR')
> endif
>
> * glAdmin is a global flag set when the user logs in to determine their
> access rights.
>
> However, because you mentioned a security level system, I remembered having
> a similar setup with one of my clients. Each user has a security level set
> between 0 and 10 where 0 is a very basic user with access to only a few
> things and 10 is Admin level which has access to everything.
>
> We have a table that stores a list of all forms and the minimum security
> level necessary to even open the form and if the user meets the minimum
> security level the form opens.
>
> In the INIT of forms, we call a method to enable or disable fields or
> buttons depending upon the specifics that take place within the form.
>
> If I had it to do over again, I'd probably try to ditch the table with the
> list of forms as I believe I could accomplish the same thing using the Load
> method to check the user security before the form init. I have done
> something similar in the past using code similar to what I show above.
>
> I'd be interested in hearing from others in how they would handle that.
>
> Paul H. Tarver
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ajoy
> Khaund
> Sent: Monday, May 14, 2018 12:29 AM
> To: profoxt...@leafe.com
> Subject: Application User Level Access
>
> Hi All,
>
> In my applications I have added a user table where there will be field to
> define the user level.
>
> Level - 1 Admin: can add users and has access to all
> Level - 2 Manager - cannot add user but has access to all others
> Level - 3 Operator - can add transactions but cannot create masters (eg.
> add/edit a customer)
>
> Now in the master entry forms in the Add & Edit button I can put some code
> to prevent
> Level 3 users from adding or editing.
>
> I want  Level - 3 users to be able to view the masters. So for them add &
> edit button will be disabled
> or some code will b there to tell them they have no access.
>
> Is there a better way?
> Any ideas which u are implementing are welcome.
>
>
> --
> Regards,
>
> Ajoy Khaund
> Neamati Road
> Bhogdoi Mukh
> Jorhat 785001
> Assam, India
>
> Tel: 91-376-2351288
> Cell: 91-94350-92287
> Mail: akha...@hotmail.com
> Mail: akha...@gmail.com
> http://teaanalyst.blogspot.com/
>
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
> - Edward  V. Berard, "Life-Cycle Approaches"
>
>
> --- 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/CAPs4RvUuJEUD8V0hu4Bb1ursqMYrZ=2zmrmiak4_knghh1j...@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: Application User Level Access

2018-05-14 Thread Ajoy Khaund

Thanks trying that way. In my case, as I of now, I don't have to remove the
middle part of a form.

On Mon, May 14, 2018 at 7:38 PM, Stephen Russell <srussell...@gmail.com>
wrote:

> Welcome to the Data Driven Life.  It gets very complicated quickly, or so I
> fell into that hole when I tried this the first time.
>
> I fond that you need to define rules in data that are set for each form.
> You hide what they shouldn't see with respect to buttons.  Moving form
> content around is where I spent way too much time.  If user access says
> that they have no right to the middle 1/3 of the screen I tried to shift
> the screen contents and I was never happy with my attempt at this.
> Currently, I cheat in HTML output when I do not render those parts.
>
> On Mon, May 14, 2018 at 12:29 AM, Ajoy Khaund <akha...@gmail.com> wrote:
>
> > Hi All,
> >
> > In my applications I have added a user table where there will be field to
> > define the user level.
> >
> > Level - 1 Admin: can add users and has access to all
> > Level - 2 Manager - cannot add user but has access to all others
> > Level - 3 Operator - can add transactions but cannot create masters (eg.
> > add/edit a customer)
> >
> > Now in the master entry forms in the Add & Edit button I can put some
> code
> > to prevent
> > Level 3 users from adding or editing.
> >
> > I want  Level - 3 users to be able to view the masters. So for them add &
> > edit button will be disabled
> > or some code will b there to tell them they have no access.
> >
> > Is there a better way?
> > Any ideas which u are implementing are welcome.
> >
> >
> > --
> > Regards,
> >
> > Ajoy Khaund
> > Neamati Road
> > Bhogdoi Mukh
> > Jorhat 785001
> > Assam, India
> >
> > Tel: 91-376-2351288
> > Cell: 91-94350-92287
> > Mail: akha...@hotmail.com
> > Mail: akha...@gmail.com
> > http://teaanalyst.blogspot.com/
> >
> >
> > "Walking on water and developing software from a specification are easy
> if
> > both are frozen."
> > - Edward  V. Berard, "Life-Cycle Approaches"
> >
> >
> > --- 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/caps4rvvv6sapaa-wbmqzvicehonhgwryxcbgthoxddqmedl...@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.

Application User Level Access

2018-05-13 Thread Ajoy Khaund

Hi All,

In my applications I have added a user table where there will be field to
define the user level.

Level - 1 Admin: can add users and has access to all
Level - 2 Manager - cannot add user but has access to all others
Level - 3 Operator - can add transactions but cannot create masters (eg.
add/edit a customer)

Now in the master entry forms in the Add & Edit button I can put some code
to prevent
Level 3 users from adding or editing.

I want  Level - 3 users to be able to view the masters. So for them add &
edit button will be disabled
or some code will b there to tell them they have no access.

Is there a better way?
Any ideas which u are implementing are welcome.


-- 
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


"Walking on water and developing software from a specification are easy if
both are frozen."
- Edward  V. Berard, "Life-Cycle Approaches"


--- 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/caps4rvvx_ptb7q4nif_su6d-krbrhgug-je-fxve0a04nrf...@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] C#: Single inheritance

2017-05-19 Thread Ajoy Khaund

Are you doing anything in C#?
I am also learning. I have made one form using winforms and trying to
understand the concepts.
However I am yet to understand how to design the classes or each master dbf
will be a class.

Ajoy Khaund

On Thu, May 18, 2017 at 5:14 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I could have swore somebody told me DotNet was MULTIPLE inheritance, where
> you could have multiple parents...which I thought was really great & cool!
> However, my Pluralsight training video just said it's SINGLE inheritance.
>
> So what language has MULTIPLE PARENT inheritance?  Java?
>
[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/CAPs4RvVYxmV+pJD3HX8AFn=7DBs3j=adw1w985aufpwamnk...@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: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-10-06 Thread Ajoy Khaund

Thanks Dave. Let me do a bit of tinkering and update you.

On Mon, Oct 3, 2016 at 10:03 PM, Dave Crozier <da...@flexipol.co.uk> wrote:

> You can set up a VPN in Win 7 no problems... Go in as though you are
> adding the machine into a new network and specify it as a VPN. If the other
> end is also using Win 7 then the VPN details will be easy to set up.
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund
> Sent: 01 October 2016 06:23
> To: profox <profox@leafe.com>
> Subject: Re: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden
>
> Dave,
>
> Thanks
>
> This VPN is included with windows or do we need to download it separately.
>
> Ajoy
>
> On Fri, Sep 30, 2016 at 8:04 PM, Dave Crozier <da...@flexipol.co.uk>
> wrote:
>
> > Ajoy,
> > Simply set up a VPN then you don't expose the SQL server to the big
> > wide world. The Microsoft VPN offering is really simple to set up and
> > robust/reliable to boot.
> >
> > Doing it this way simply makes your external PC an extension of the
> > local LAN so you don't need any complicated firewall hacks and it is
> > available everywhere using the same credentials.
> >
> > Dave
> >
> >
> > -Original Message-
> > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy
> > Khaund
> > Sent: 29 September 2016 18:12
> > To: profox <profox@leafe.com>
> > Subject: Re: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden
> >
> > ok thanks.
> >
> > Mike u are into MySQL for your apps. Are your clients connecting to
> > local databases or online databases.
> >
> > If local databases then if someone wants to connect from another
> > location how can it be done. Add IPAddress to the connection string?
> >
> > If online databases how are you setting the firewall settings for
> > allowing ipaddress.
> >
> >
> > I tried MS Azure. I have a dynamic Ipaddress so I realized every time
> > I reconnect to the internet I have to reset the firewall settings in
> > Azure to let my pc connect. I was planning something similar for my
> > client when he travels. If he connects from a hotel he wont be able to
> > keep resetting the firewall. How to go about that?
> >
> > Similarly how to prevent any hackers from accessing the local database
> > vide internet & deleting all data.
> >
> > Thanks
> >
> > This is open to all. maybe I will have to open a new thread.
> >
> > On Thu, Sep 29, 2016 at 3:02 AM, <
> > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> > > Hi Bobby,
> > >
> > > I use it to remote into clients and fix things, but also to switch
> > > screens and show them something on my screen perhaps too (like the
> > > next development item in Testing, for example).
> > >
> > > --Mike
> > >
> > >
> > > On 2016-09-28 06:16, Ajoy Khaund wrote:
> > >
> > >> Mike,
> > >>
> > >> Are you using Teamviewer only for remote support or if in any other
> > >> ways please let me know.
> > >>
> > >> I use anydesk or anyadmin to fix problems.
> > >>
> > >> Thanks
> > >>
> > >> Ajoy Khaund
> > >>
> > >>
> > >> On Sat, Sep 24, 2016 at 1:49 AM, <
> > >> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> > >>
> > >> On 2016-05-07 10:04, Ted Roche wrote:
> > >>>
> > >>> *POKE* Michael, any progress, resolution or clues on this? It's
> > >>>> unusual for posts here to be unresolved after 11 days.
> > >>>>
> > >>>>
> > >>>
> > >>> Ted -- sorry...found this draft I started 4 months ago and never
> > >>> pressed Send.
> > >>>
> > >>> Somehow the issue has been resolved.  I did upgrade to TeamViewer
> > >>> 11 recently.  Not sure if that was the fix or not?  So glad the
> > >>> upgrade price was a few hundred instead of the $1000 they initially
> wanted.
> > >>> :-)
> > >>>
> > >>> Thanks again for asking!
> > >>> --Mike
> > >>>
> > >>>
> > >>>
[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/caps4rvvfcs9xwaphojsecurjtaqx3agnww-ztvz0en_hcz2...@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: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-09-30 Thread Ajoy Khaund

Dave,

Thanks

This VPN is included with windows or do we need to download it separately.

Ajoy

On Fri, Sep 30, 2016 at 8:04 PM, Dave Crozier <da...@flexipol.co.uk> wrote:

> Ajoy,
> Simply set up a VPN then you don't expose the SQL server to the big wide
> world. The Microsoft VPN offering is really simple to set up and
> robust/reliable to boot.
>
> Doing it this way simply makes your external PC an extension of the local
> LAN so you don't need any complicated firewall hacks and it is available
> everywhere using the same credentials.
>
> Dave
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund
> Sent: 29 September 2016 18:12
> To: profox <profox@leafe.com>
> Subject: Re: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden
>
> ok thanks.
>
> Mike u are into MySQL for your apps. Are your clients connecting to local
> databases or online databases.
>
> If local databases then if someone wants to connect from another location
> how can it be done. Add IPAddress to the connection string?
>
> If online databases how are you setting the firewall settings for allowing
> ipaddress.
>
>
> I tried MS Azure. I have a dynamic Ipaddress so I realized every time I
> reconnect to the internet I have to reset the firewall settings in Azure to
> let my pc connect. I was planning something similar for my client when he
> travels. If he connects from a hotel he wont be able to keep resetting the
> firewall. How to go about that?
>
> Similarly how to prevent any hackers from accessing the local database
> vide internet & deleting all data.
>
> Thanks
>
> This is open to all. maybe I will have to open a new thread.
>
> On Thu, Sep 29, 2016 at 3:02 AM, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > Hi Bobby,
> >
> > I use it to remote into clients and fix things, but also to switch
> > screens and show them something on my screen perhaps too (like the
> > next development item in Testing, for example).
> >
> > --Mike
> >
> >
> > On 2016-09-28 06:16, Ajoy Khaund wrote:
> >
> >> Mike,
> >>
> >> Are you using Teamviewer only for remote support or if in any other
> >> ways please let me know.
> >>
> >> I use anydesk or anyadmin to fix problems.
> >>
> >> Thanks
> >>
> >> Ajoy Khaund
> >>
> >>
> >> On Sat, Sep 24, 2016 at 1:49 AM, <
> >> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >>
> >> On 2016-05-07 10:04, Ted Roche wrote:
> >>>
> >>> *POKE* Michael, any progress, resolution or clues on this? It's
> >>>> unusual for posts here to be unresolved after 11 days.
> >>>>
> >>>>
> >>>
> >>> Ted -- sorry...found this draft I started 4 months ago and never
> >>> pressed Send.
> >>>
> >>> Somehow the issue has been resolved.  I did upgrade to TeamViewer 11
> >>> recently.  Not sure if that was the fix or not?  So glad the upgrade
> >>> price was a few hundred instead of the $1000 they initially wanted.
> >>> :-)
> >>>
> >>> Thanks again for asking!
> >>> --Mike
> >>>
> >>>
> >>>
[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/CAPs4RvVoWuR6qSutZsFmrXmxF1fiz4jE3EnVQ2WfqAfBb=t...@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: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-09-29 Thread Ajoy Khaund

ok thanks.

Mike u are into MySQL for your apps. Are your clients connecting to local
databases or online databases.

If local databases then if someone wants to connect from another location
how can it be done. Add IPAddress to the connection string?

If online databases how are you setting the firewall settings for allowing
ipaddress.

I tried MS Azure. I have a dynamic Ipaddress so I realized every time I
reconnect to the internet I have to reset the firewall settings in Azure to
let my pc connect. I was planning something similar for my client when he
travels. If he connects from a hotel he wont be able to keep resetting the
firewall. How to go about that?

Similarly how to prevent any hackers from accessing the local database vide
internet & deleting all data.

Thanks

This is open to all. maybe I will have to open a new thread.

On Thu, Sep 29, 2016 at 3:02 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Hi Bobby,
>
> I use it to remote into clients and fix things, but also to switch screens
> and show them something on my screen perhaps too (like the next development
> item in Testing, for example).
>
> --Mike
>
>
> On 2016-09-28 06:16, Ajoy Khaund wrote:
>
>> Mike,
>>
>> Are you using Teamviewer only for remote support or if in any other ways
>> please let me know.
>>
>> I use anydesk or anyadmin to fix problems.
>>
>> Thanks
>>
>> Ajoy Khaund
>>
>>
>> On Sat, Sep 24, 2016 at 1:49 AM, <
>> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>>
>> On 2016-05-07 10:04, Ted Roche wrote:
>>>
>>> *POKE* Michael, any progress, resolution or clues on this? It's
>>>> unusual for posts here to be unresolved after 11 days.
>>>>
>>>>
>>>
>>> Ted -- sorry...found this draft I started 4 months ago and never pressed
>>> Send.
>>>
>>> Somehow the issue has been resolved.  I did upgrade to TeamViewer 11
>>> recently.  Not sure if that was the fix or not?  So glad the upgrade
>>> price
>>> was a few hundred instead of the $1000 they initially wanted.  :-)
>>>
>>> Thanks again for asking!
>>> --Mike
>>>
>>>
>>>
[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/caps4rvxcaem3vmcdfhtudqz-oarynhagmgwzcj1p2-msnrn...@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: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-09-28 Thread Ajoy Khaund

Thanks Dave. Wasn't aware of splashtop.

On Wed, Sep 28, 2016 at 9:23 PM, Dave Crozier <da...@flexipol.co.uk> wrote:

> Short answer is NO, I use Splashtop Business here which incorporates
> Splashtop SOS after I became totally disillusioned by the pricing policy of
> Teamviewer which at that time was only superior because it included file
> transfer.
>
> However, the last few revisions of Splashtop not have this facility
> available as background jobs.
>
> Dave
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund
> Sent: 28 September 2016 11:17
> To: profox <profox@leafe.com>
> Subject: Re: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden
>
> Mike,
>
> Are you using Teamviewer only for remote support or if in any other ways
> please let me know.
>
> I use anydesk or anyadmin to fix problems.
>
> Thanks
>
> Ajoy Khaund
>
>
> On Sat, Sep 24, 2016 at 1:49 AM, <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > On 2016-05-07 10:04, Ted Roche wrote:
> >
> >> *POKE* Michael, any progress, resolution or clues on this? It's
> >> unusual for posts here to be unresolved after 11 days.
> >>
> >
> >
> > Ted -- sorry...found this draft I started 4 months ago and never
> > pressed Send.
> >
> > Somehow the issue has been resolved.  I did upgrade to TeamViewer 11
> > recently.  Not sure if that was the fix or not?  So glad the upgrade
> > price was a few hundred instead of the $1000 they initially wanted.
> > :-)
> >
> > Thanks again for asking!
> > --Mike
> >
> >
> >
[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/caps4rvvbj1vmvxc9ca06vivtrp4cqkt9ulvdobpe0qbkwre...@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: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-09-28 Thread Ajoy Khaund

Mike,

Are you using Teamviewer only for remote support or if in any other ways
please let me know.

I use anydesk or anyadmin to fix problems.

Thanks

Ajoy Khaund

On Sat, Sep 24, 2016 at 1:49 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2016-05-07 10:04, Ted Roche wrote:
>
>> *POKE* Michael, any progress, resolution or clues on this? It's
>> unusual for posts here to be unresolved after 11 days.
>>
>
>
> Ted -- sorry...found this draft I started 4 months ago and never pressed
> Send.
>
> Somehow the issue has been resolved.  I did upgrade to TeamViewer 11
> recently.  Not sure if that was the fix or not?  So glad the upgrade price
> was a few hundred instead of the $1000 they initially wanted.  :-)
>
> Thanks again for asking!
> --Mike
>
>
>
[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/caps4rvv0afkw0eyquqfrby4gccgnt8wnr6eo1n-jkm9kksn...@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: Generate a report in local language (India)

2016-07-19 Thread Ajoy Khaund

Yes I think in a way that will be the best & maybe easiest option.
Thanks a lot.

On Mon, Jul 18, 2016 at 7:46 PM, Kurt Wendt <kurt_we...@globetax.com> wrote:

> Ajoy - I understand its Only the printing of the Gross Salary which you
> want to change to a different language.
>
> I remember doing something years ago in an app I worked on for a job.
> Don't remember Exactly the details and what exactly I was trying to print.
> I DO Remember that the characters were LARGE. And, I believe they were
> Numbers. So - in theory - you could create graphic images of the symbols
> you want to print for the salary - and then print a set of those images to
> produce the salary amount in your required language. I know - sounds like a
> lot of work - but, it is one potential option...
>
> Regards,
> Kurt Wendt
> Senior Systems Analyst
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ajoy
> Khaund
> Sent: Monday, July 18, 2016 8:24 AM
> To: profoxt...@leafe.com
> Subject: Re: Generate a report in local language (India)
>
> I have no idea how to write an access program (sob).
> Anyway Thanks
>
> On Mon, Jul 18, 2016 at 4:27 PM, Man-wai Chang <chan...@gmail.com> wrote:
>
> > BTW, don't forget about Micro$oft Office. OLE automation to print to
> > Excel? Calling an Access program that just print reports?
> >
> > On Mon, Jul 18, 2016 at 6:12 PM, Ajoy Khaund <akha...@gmail.com> wrote:
> > > Thanks all of you.
> > >
> >
> > --
> >  .~. Might, Courage, Vision. SINCERITY!
> > / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\
> > http://sites.google.com/site/changmw
> > ^ ^ May the Force and farces be with you!
> >
[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/caps4rvvugxj312qbm32-gsj4exkdgt+k_ejyhvhpnfvcrdh...@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: Generate a report in local language (India)

2016-07-18 Thread Ajoy Khaund

I have no idea how to write an access program (sob).
Anyway Thanks

On Mon, Jul 18, 2016 at 4:27 PM, Man-wai Chang <chan...@gmail.com> wrote:

> BTW, don't forget about Micro$oft Office. OLE automation to print to
> Excel? Calling an Access program that just print reports?
>
> On Mon, Jul 18, 2016 at 6:12 PM, Ajoy Khaund <akha...@gmail.com> wrote:
> > Thanks all of you.
> >
>
> --
>  .~. Might, Courage, Vision. SINCERITY!
> / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
>
[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/CAPs4RvVpM8jfP-PFU3QK=wh2vuxcpeqgnqspnpmfio46dny...@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: Generate a report in local language (India)

2016-07-18 Thread Ajoy Khaund

Thanks all of you.

Ted from google I did read the link you have given. That will be be the
first step I have to cross.


Jose Enrique Llopis: I will try to download your demo and check

Man-wai Chang: Yes I am sure crystal report will be the best to print.
Infact I was checking the price. Lets see if I can download a demo.

Thanks again

On Mon, Jul 18, 2016 at 12:27 AM, José Enrique Llopis <fut...@lobocom.es>
wrote:

>
> My Real Estate CRM prints reports in Russian and chinese, it works printing
> a RTF with a general field, you can find a lot of samples of how to print
> RTF content in a report in foxite. To save the rtf data I use the richtext
> activeX and content is stored in a general field.
>
> You can download a demo version from my Website: www.multilinkcrm.com and
> test if it works in Indian language.
>
> I'm now translating the interface to English but at this moment is only
> available in Spanish, perhaps in two month or so, sorry.
>
> Jose Enrique Llopis
>
>
>
>
>
>
>
>
> -Mensaje original-
> De: ProFox [mailto:profox-boun...@leafe.com] En nombre de Ted Roche
> Enviado el: domingo, 17 de julio de 2016 16:38
> Para: profox@leafe.com
> Asunto: Re: Generate a report in local language (India)
>
> VFP was one of the first MS apps to support internationalization, but
> it was designed to work with the multi-byte character set (MBCS) and
> Code Pages that were the Microsoft solution, instead of the
> then-nascent Unicode efforts. Consequently, Unicode support in VFP is
> difficult and not the native behavior, so your success may depend on
> whether there is good support of Assamese in code pages and MBCS
> fonts.
>
> I've only done internationalization with European languages sharing
> their common character set, so I'm not sure of all the issues you may
> run into.
>
> The reference tool in the VFP world is Intl,
> http://stevenblack.com/intl/. Check out the GOTCHAS link and
> VFP International Issues" also listed on that page for some suggestions.
>
> Good luck!
>
>
> On Sat, Jul 16, 2016 at 11:26 AM, Ajoy Khaund <akha...@gmail.com> wrote:
> > Dear All,
> >
> > I need to know if I can generate the payslip of a worker in my payroll
> > module in
> > Assamese (Local language of Assam in India).
> >
> > We are using English(UnitedStates) languge windows OS.
> >
> > Fonts for this local language are available. Is it possible to change
> > say the Gross Salary from English to another language while printing.
> >
> > Kindly point me in the right direction.
> >
> > Thanks all.
> >
> > --
> > Regards,
> >
> > Ajoy Khaund
> > Neamati Road
> > Bhogdoi Mukh
> > Jorhat 785001
> > Assam, India
> >
> > Tel: 91-376-2351288
> > Cell: 91-94350-92287
> > Mail: akha...@hotmail.com
> > Mail: akha...@gmail.com
> > http://teaanalyst.blogspot.com/
> >
> >
> > "Walking on water and developing software from a specification are easy
> if
> > both are frozen."
> > - Edward  V. Berard, "Life-Cycle Approaches"
> >
> >
> > --- 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/caps4rvx_um1vtdxs8ygzauqpseiur58kcmidy9tuegvply_...@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: Generate a report in local language (India)

2016-07-17 Thread Ajoy Khaund

Not sure about it.
I think I will need a field which will be able to store the data in the
format
which the local font will be able to read (in unicode in a blog field
maybe).

On Sun, Jul 17, 2016 at 4:40 PM, Man-wai Chang <chan...@gmail.com> wrote:

> You can use IIF(m.language="E", "English", :"Assamese") where
> m.language is a global variable.
>
> On Sat, Jul 16, 2016 at 11:26 PM, Ajoy Khaund <akha...@gmail.com> wrote:
> > Fonts for this local language are available. Is it possible to change
> > say the Gross Salary from English to another language while printing.
>
> --
>  .~. Might, Courage, Vision. SINCERITY!
> / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
>
[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/CAPs4RvWdZN4_QRLnqbz=pneqvovxcb5g+671xa2jdjapm1b...@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.

Generate a report in local language (India)

2016-07-16 Thread Ajoy Khaund

Dear All,

I need to know if I can generate the payslip of a worker in my payroll
module in
Assamese (Local language of Assam in India).

We are using English(UnitedStates) languge windows OS.

Fonts for this local language are available. Is it possible to change
say the Gross Salary from English to another language while printing.

Kindly point me in the right direction.

Thanks all.

-- 
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


"Walking on water and developing software from a specification are easy if
both are frozen."
- Edward  V. Berard, "Life-Cycle Approaches"


--- 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/CAPs4RvWeCCjsfXUGTqrKTcVNqS4n5bPpHKg=wvwk+kp6xvg...@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: Data Entry Form using Sql Server SPT

2014-06-24 Thread Ajoy Khaund

Dave,
Thanks for the write up. I got it going. There were some hiccups ofcourse.

How do you create a data object?

Do you create a class with all fields of the table as properties?

Please let me know as I want to make the same form in all the ways possible
and then choose which I like best.

Initially I liked CA's but then found SPT to be easier.

Thanks

Ajoy Khaund

On Tue, Jun 24, 2014 at 2:07 PM, Dave Crozier da...@flexipol.co.uk wrote:

Ajoy,
The usual procedure of using a data object which is an object containing
the current, or in the case of a new record, a blank set of data is used.
You do the changes to the data object by binding the object properties to
the form controls (textbox etc) and then you can freely manipulate the data
in your program using business logic to validate the fields and then commit
the object for writing to the database - or adding if it is a new record.

I won't go into the areas of Biz objects at this time as it opens up a
whole area of discussion but simply but in simple terms you

1. Load the form

2. In the form init() create an object property to hold the current record
or blank record as an object with properties and bind the object properties
to the form controls.

3. Get the data record from the underlying table then Scatter the data
from the record into the form data object. You can scatter a blank record
which will set the data object up for insertion (see scatter blank memo)

4. Enter/Modify and/or validate the data object properties using standard
controls on the form as the data will now be bound to the form controls.
Nothing is written away to the DB at this time and only the data object is
modified

5. If you want to write the data back to the DB then gather the data back
from the form data object and write/commit it to the underlying DB table.

In this way you can use the same logic on VFP or SQL remote data as the
only change needed is the rear/write functions. You can do this using SPT
or Table adapters. Personally I don't like TA's, but this is just my
opinion.

Please don't take this as the only way top do it as I am just trying to
show you how you need to separate the data from the underlying database by
loading it into an object upon which you perform all the data
manipulation/verification etc before writing it away.

Dave

[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/caps4rvu7tqkzjgwa9cnqmc7iewrjk+kpxnfmqdvrqdfnprn...@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: Data Entry Form using Sql Server SPT

2014-06-24 Thread Ajoy Khaund

My vfp forms connected to master tables are been coded using this method.
I have the controls on a pageframe on the first page with
Add,Edit,Delete,find navigation buttons.
In my second page I have the data in a grid of main columns.

More then one page I have for say products table etc.

Thanks how are you creating the views?

Please let me know. I saw the makeupdateable function in the downloads.
Is it that?

Ajoy Khaund

On Tue, Jun 24, 2014 at 5:09 PM, Eurico Chagas Filho e28cha...@yahoo.com.br
wrote:

I use views for all tables that I need to open.
Each form has a pageframe, the first page opens a grid
that shows, say, all customers in order chosen by the header of the
columns.
In this first page there three buttons, select, new and exit.
In the second page that comes up, in the bottom, there are seven buttons.
They are, auto( save and new), back, redo, new, refresh, save, delete.
If needed u can have more pages, then in the second page on the left u can
select the other pages, but the bottom buttons remain for all pages.

HTH, E.

On Tuesday, June 24, 2014 8:12 AM, AndyHC jarnd...@gmail.com wrote:

Dave Crozier +1
- you could also consider using a CursorAdapter [as a data object].
There is a builder available, and as VFP Help! suggests: see Data Access
Management Using CursorAdapters
/html/5bf4efc5-39e7-4fc9-b785-876d4315486f.htm.

--- 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/CAPs4RvWKe=+hmew2hvni0gt8rcgonroc7dmpvjbmouta+0k...@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: Data Entry Form using Sql Server SPT

2014-06-24 Thread Ajoy Khaund

Thanks Dave.
So are controls on the form like textboxes bound to the cursor or
Thisform.oData_Obj ?

Ajoy Khaund

On Tue, Jun 24, 2014 at 9:15 PM, Dave Crozier da...@flexipol.co.uk wrote:

First Point to any record of the data held in a cursor (usually done in
the Load of the form where you can get the data structure)

* Create a data Object
Thisform.AddProperty(oData_Obj, null)
*
* Populate the data object inc memo fields but with blank data
oObj=Thisform.oData_Obj
scatter name oObj memo blank

The object Thisform.oData_Obj will then contain a list of properties
relating to each field name in the cursor
e.g try opening the oObj in the debugger and you will see the properties

? oObj.character_field_1

so you end up with Properties like:
oObj.Customer_Id
oObj.Primary_Key ... etc etc

The addition of the word blank after the scatter simply initializes the
object with field properties containing no data.

When you come to disperse the data back to your underlying tables, in VFP
assuming you are pointing at the correct record to update it is simple done
by:

oObj=Thisform.oData_Obj
*
select cursor
gather name oObj memo

Once again gon't gorget the word memo or any binary/blob or memo fields
will not be gathered.

You can use the same technique to update the SPT cursor for committing to
the non DB table.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund
Sent: 24 June 2014 15:51
To: profox
Subject: Re: Data Entry Form using Sql Server SPT

Dave,
Thanks for the write up. I got it going. There were some hiccups ofcourse.

How do you create a data object?

Do you create a class with all fields of the table as properties?

Please let me know as I want to make the same form in all the ways
possible and then choose which I like best.

Initially I liked CA's but then found SPT to be easier.

Thanks

Ajoy Khaund

On Tue, Jun 24, 2014 at 2:07 PM, Dave Crozier da...@flexipol.co.uk
wrote:

Ajoy,
The usual procedure of using a data object which is an object
containing the current, or in the case of a new record, a blank set of
data is used.
You do the changes to the data object by binding the object properties
to the form controls (textbox etc) and then you can freely manipulate
the data in your program using business logic to validate the fields
and then commit the object for writing to the database - or adding if it
is a new record.

I won't go into the areas of Biz objects at this time as it opens up a
whole area of discussion but simply but in simple terms you

1. Load the form

2. In the form init() create an object property to hold the current
record or blank record as an object with properties and bind the
object properties to the form controls.

3. Get the data record from the underlying table then Scatter the data
from the record into the form data object. You can scatter a blank
record which will set the data object up for insertion (see scatter
blank memo)

4. Enter/Modify and/or validate the data object properties using
standard controls on the form as the data will now be bound to the form
controls.
Nothing is written away to the DB at this time and only the data
object is modified

5. If you want to write the data back to the DB then gather the data
back from the form data object and write/commit it to the underlying
DB table.

In this way you can use the same logic on VFP or SQL remote data as
the only change needed is the rear/write functions. You can do this
using SPT or Table adapters. Personally I don't like TA's, but this is
just my opinion.

Please don't take this as the only way top do it as I am just trying
to show you how you need to separate the data from the underlying
database by loading it into an object upon which you perform all the
data manipulation/verification etc before writing it away.

Dave

[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/CAPs4RvU8wd+5NOpaqfkpDvbp5Du6-20=V5cG=6xk_klxef1...@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.

Data Entry Form using Sql Server SPT

2014-06-23 Thread Ajoy Khaund

Hi Folks,

In my vfp apps in a form I generally have a Add Edit button along
with navigation buttons. On clicking on Add btn say an append blank is
issued. The caption of Add Edit button changes to Save
revert...

How are you all approaching this with back end servers. Say to enter
data to a table
having about 10 fields. In some apps I have seen a form with blank
controls. The user enters data and click on a Insert or Add Rec. or
Save button.

To edit a record there is a Find button on retrieving the records
make changes and click on Save or Update button.

Your inputs will help me to get the approach right.

Thanks a lot.

--
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward V. Berard, Life-Cycle Approaches

___
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/caps4rvwqnfpwfnx4kpu3pxc1orqlpcsf46pkz+fupuhstet...@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: EPS Software would like to give you a free subscription to CODE Magazine!

2013-04-03 Thread Ajoy Khaund

https://www.code-magazine.com/Subscription.aspx?ref=Foxfree


On Wed, Apr 3, 2013 at 12:51 PM, Alan Bourke alanpbou...@fastmail.fmwrote:

 That link is giving me an ASP error page!

[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/CAPs4RvWffYx=5VtvOEPs+B5hB4TS=z4zn4btes5dzv+5w7m...@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: Update table using SPT

2013-02-14 Thread Ajoy Khaund

Thanks Dave.
Finally understood what the MakeUpdateable.prg was all about.
I use to see people refering to it but never realized what it was for.

Thanks Paul McNett.

Is there any problem if the name of the backendtable local alias has the
same name.
Since I am converting Vfp forms life will be easier if they can be both
same.
Just want to know in advance so that I don't fall into any trap.

Ajoy Khaund

On Thu, Feb 14, 2013 at 1:41 PM, Dave Crozier da...@flexipol.co.uk wrote:

Ajoy,
If you are using SPT and you are retrieving a cursor from SQL Server then
you set the attributes of the cursor to reflect the update behaviour using
cursorsetprop().

You need to set the Keyfieldlist, Tables, UpdatableFieldList, Updatetype
and Wheretype properties. Then the cursor will update automatically using
the tableupdate() method.

To check if any fields have been updated in the cursor you can use the VFP
OLDVAL() function to determine if any field has changed or set your own
trigger in the Interactivechange event of the fields on the form.

As for updating, you can obviously also update individual records using
spt in standard SQl i.e update cursor set oldfield = newfield where
where if you want.

It is also worth looking at tableadapters as they take all the hard work
out of SQL if you are averse to manually programming. Personally I don't
like them but I do use them on occasions. Create the cursoradapter them to
a separate class for ease of re-use then you can easily add them into your
dataenvironment and just use them like native VFP cursors.

On Profox there is a small routine MakeCursorUpdateable (I think) by Paul
McNett that will point you in the right direction for cursorsetprop() if
you are confused by the VFP documentation. I must admit that the
documentation isn't great. Alternatively ask away on here.

I have my own set of classes that do all the SQL stuff automatically that
you could have but I think it would be too complex at the level you are
currently at. Once you master cursors in SPT they it may be of use to you.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund
Sent: 14 February 2013 03:49
To: Profox
Subject: Update table using SPT

Hi All,

I am working on MSSQL for an app. I am in the learning stage. I am using
SPT. I have a query.

I have an employee master form.
In the load event I can query and get all the records down to a cursor. I
have an edit button in the form. Now the user may edit one or more fields
in the form say having 50 fields.

On save how do I write the UPDATE command if the user has say edited two
fields. How will the app know that?

TIA

--
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward V. Berard, Life-Cycle Approaches

--- 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/caps4rvuv0mkzwhmr1azdyx1uljmxzaom65apkurqj+79mxv...@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: What font do you use in your coding window?

2013-02-13 Thread Ajoy Khaund

Thanks Thierry.

Now I have to get the size of fonts for code inside forms.


On Wed, Feb 13, 2013 at 8:26 AM, Thierry Nivelet tnive...@foxincloud.comwrote:

 tools  options  IDE  override individual settings
 Thierry Nivelet
 FoxinCloud
 Give your VFP app a new life in the cloud
 http://foxincloud.com/

 Le 12 févr. 2013 à 20:46, Ajoy Khaund a écrit :

  Is there any way to change the font size for all code in prgs  forms in
 a
  project?
 
  Ajoy Khaund
 
 
  On Thu, Feb 7, 2013 at 10:21 PM, Dave Crozier da...@flexipol.co.uk
 wrote:
 
  Tahoma
 
  Dave C
 
  -Original Message-
  From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software
  Solutions, LLC
  Sent: 07 February 2013 16:46
  To: ProFox Email List
  Subject: What font do you use in your coding window?
 
  VFP9SP2 (not that it matters)
 
  I've been a Courier New man for a long time, but am considering a
 change.
  What do you use?
 
  --
  Mike Babcock, MCP
  MB Software Solutions, LLC
  President, Chief Software Architect
  http://mbsoftwaresolutions.com
  http://fabmate.com
  http://twitter.com/mbabcock16
 
[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/caps4rvw_bpiq0zgzgmp55rutp_5wfjgd7wo0rh9atxom3_f...@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: What font do you use in your coding window?

2013-02-12 Thread Ajoy Khaund

Is there any way to change the font size for all code in prgs  forms in a
project?

Ajoy Khaund


On Thu, Feb 7, 2013 at 10:21 PM, Dave Crozier da...@flexipol.co.uk wrote:

 Tahoma

 Dave C

 -Original Message-
 From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software
 Solutions, LLC
 Sent: 07 February 2013 16:46
 To: ProFox Email List
 Subject: What font do you use in your coding window?

 VFP9SP2 (not that it matters)

 I've been a Courier New man for a long time, but am considering a change.
  What do you use?

 --
 Mike Babcock, MCP
 MB Software Solutions, LLC
 President, Chief Software Architect
 http://mbsoftwaresolutions.com
 http://fabmate.com
 http://twitter.com/mbabcock16

[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/CAPs4RvX4Cd3ywy-DFuF6QOgbsrR=hlgx7ayot536w60wvsd...@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: Win XP Pro SP1 Version 2002

2012-05-25 Thread Ajoy Khaund

Thanks. In somes places thay have said to use toothpaste. I dont know.

On Thu, May 24, 2012 at 8:29 PM, Michael Madigan mmadi10...@yahoo.comwrote:

 http://www.wisebread.com/quickly-removing-scratches-from-cds-and-dvds


 http://www.instructables.com/id/Re-surfacing-CDs-so-they-work-again./



 https://www.google.com/search?rlz=1C1RNPN_enUS430US430aq=2oq=getting+a+scratched+cd+to+sugexp=chrome,mod=17sourceid=chromeie=UTF-8q=how+do+i+get+a+scratched+cd+to+work




 - Original Message -
 From: Ajoy Khaund akha...@gmail.com
 To: profox@leafe.com
 Cc:
 Sent: Wednesday, May 23, 2012 9:13 PM
 Subject: Re: Win XP Pro SP1 Version 2002

 We checked using another CD drive also but not on another PC.

 On Thu, May 24, 2012 at 2:04 AM, Nicholas Geti ng...@optonline.net
 wrote:

  I have seen some pretty well-scratched CDs that still worked. Do you have
  another CD drive to test? Or another PC?
 
  - Original Message -
  From: Ajoy Khaund akha...@gmail.com
  To: profox@leafe.com
  Sent: Wednesday, May 23, 2012 2:03 PM
  Subject: Re: Win XP Pro SP1 Version 2002
 
 
   Kurt you are right.
  
   The WinXp CD which I have is original. I had no problem for the last 8
   years. I must
   have used it three times or so. My cd drive is about 12 years old so
 that
   must have
   spoilt the CD with use.
  
   If I had a pirated XP CD I would not have asked in this forum of which
 I
   have been a member
   for quite a no. of years.
  
   Anyway no hard feelings I hope.
  
   Thanks
  
  
  
   On Wed, May 23, 2012 at 8:47 PM, Kurt Wendt kurtwe...@waitex.com
  wrote:
  
   Nicholas - I think its possible you may be jumping to conclusions! I
   think Ajoy bought a legit copy of Windows. But, now that he has a
   problem - and its an OLD OS to begin with - now he has a serious
 problem
   trying to fix it. He simply brought up the fact that others within his
   country get illegal versions of SW - but, that does NOT mean that he
   did.
  
   Of course - Ajoy - feel free to jump in here - in case I have
 something
   wrong.  (Although - considering where he is from - he is probably
   sleeping right now - while the rest of us are slaving away at work...)
   :-)
  
   -K-
  
   -Original Message-
   From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
   Behalf Of Nicholas Geti
   Sent: Tuesday, May 22, 2012 10:26 PM
  
   Oh, I knew alright. I am amazed that this fellow said it explicitly. I
   am
   not about to send him any help.
  
  
   - Original Message -
   From: Kurt Wendt kurtwe...@waitex.com
   To: ProFox Email List profox@leafe.com
  
  
Nicholas - you really don't know?
   
I think it was a buddy of mine from Pakistan - told me he goes into
these stores - and you can get almost ANY SW - and they burn a copy
   onto
a CD for you - SUPER Cheap - and they even have Copies of books -
 and
   I
saw one - it was like a paper back book - a BIG book - but, the
 pages
   -
they were like Newspaper print! Really strange indeed.
   
So - no - I don't think he means people steal it - but, rather -
 they
get it free or super cheap - but, in the end - its kinda the same
   thing.
Other countries don't have the same issue w/SW Piracy that we have
   here
in the USA (Not sure where you are located) - but, more and more ARE
Cracking down - even in China!
   
And - of course - you know that Microsoft has a whole division that
   goes
on MAJOR Busts to stop trafficking of illegal SW - and they work
 with
the FBI and do Stings. I read about it a while ago - and I think
 there
were big Sting Ops going on at that time in Mexico! There exists
   REALLY
BIG Operations and money made in illegal software sales!
   
-K-
   
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti
   
Are you needing a Windows Recovery CD or the Foxpro CD?
Do you mean everyone there is stealing the software?
   
  
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/caps4rvup8xqo60_tw0tqrx3acp7ngxrn+e2rdd1cbsx4pfx...@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: Win XP Pro SP1 Version 2002

2012-05-23 Thread Ajoy Khaund

Kurt you are right.

The WinXp CD which I have is original. I had no problem for the last 8
years. I must
have used it three times or so. My cd drive is about 12 years old so that
must have
spoilt the CD with use.

If I had a pirated XP CD I would not have asked in this forum of which I
have been a member
for quite a no. of years.

Anyway no hard feelings I hope.

Thanks

On Wed, May 23, 2012 at 8:47 PM, Kurt Wendt kurtwe...@waitex.com wrote:

Nicholas - I think its possible you may be jumping to conclusions! I
think Ajoy bought a legit copy of Windows. But, now that he has a
problem - and its an OLD OS to begin with - now he has a serious problem
trying to fix it. He simply brought up the fact that others within his
country get illegal versions of SW - but, that does NOT mean that he
did.

Of course - Ajoy - feel free to jump in here - in case I have something
wrong. (Although - considering where he is from - he is probably
sleeping right now - while the rest of us are slaving away at work...)
:-)

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti
Sent: Tuesday, May 22, 2012 10:26 PM

Oh, I knew alright. I am amazed that this fellow said it explicitly. I
am
not about to send him any help.

- Original Message -
From: Kurt Wendt kurtwe...@waitex.com
To: ProFox Email List profox@leafe.com

Nicholas - you really don't know?

I think it was a buddy of mine from Pakistan - told me he goes into
these stores - and you can get almost ANY SW - and they burn a copy
onto
a CD for you - SUPER Cheap - and they even have Copies of books - and
I
saw one - it was like a paper back book - a BIG book - but, the pages
-
they were like Newspaper print! Really strange indeed.

So - no - I don't think he means people steal it - but, rather - they
get it free or super cheap - but, in the end - its kinda the same
thing.
Other countries don't have the same issue w/SW Piracy that we have
here
in the USA (Not sure where you are located) - but, more and more ARE
Cracking down - even in China!

And - of course - you know that Microsoft has a whole division that
goes
on MAJOR Busts to stop trafficking of illegal SW - and they work with
the FBI and do Stings. I read about it a while ago - and I think there
were big Sting Ops going on at that time in Mexico! There exists
REALLY
BIG Operations and money made in illegal software sales!

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti

Are you needing a Windows Recovery CD or the Foxpro CD?
Do you mean everyone there is stealing the software?

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/caps4rvwtiwzjhnmgt6re+wgs6c6and4jkx2cunyqsajufnv...@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: Win XP Pro SP1 Version 2002

2012-05-23 Thread Ajoy Khaund

We checked using another CD drive also but not on another PC.

On Thu, May 24, 2012 at 2:04 AM, Nicholas Geti ng...@optonline.net wrote:

I have seen some pretty well-scratched CDs that still worked. Do you have
another CD drive to test? Or another PC?

- Original Message -
From: Ajoy Khaund akha...@gmail.com
To: profox@leafe.com
Sent: Wednesday, May 23, 2012 2:03 PM
Subject: Re: Win XP Pro SP1 Version 2002

Kurt you are right.

The WinXp CD which I have is original. I had no problem for the last 8
years. I must
have used it three times or so. My cd drive is about 12 years old so that
must have
spoilt the CD with use.

If I had a pirated XP CD I would not have asked in this forum of which I
have been a member
for quite a no. of years.

Anyway no hard feelings I hope.

Thanks

On Wed, May 23, 2012 at 8:47 PM, Kurt Wendt kurtwe...@waitex.com
wrote:

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti
Sent: Tuesday, May 22, 2012 10:26 PM

Oh, I knew alright. I am amazed that this fellow said it explicitly. I
am
not about to send him any help.

- Original Message -
From: Kurt Wendt kurtwe...@waitex.com
To: ProFox Email List profox@leafe.com

Nicholas - you really don't know?

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti

Are you needing a Windows Recovery CD or the Foxpro CD?
Do you mean everyone there is stealing the software?

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/caps4rvw1xefd8cicpe+0q4knowwim70ournars51f3be5rd...@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: Win XP Pro SP1 Version 2002

2012-05-23 Thread Ajoy Khaund

If the best option is to buy another CD then I can do that here also but
then I would rather change the
PC(as it was purchased around 2006 or 2007) and go for Win7. Right now I am
using the big monitor
with my laptop and enjoying.

On Thu, May 24, 2012 at 2:35 AM, Michael Madigan mmadi10...@yahoo.comwrote:

There are many CDs available on eBay. I'm sure you can find a dealer that
will ship to your country..

http://www.ebay.com/sch/i.html?_trksid=p5197.m570.l1313_nkw=window+xp_sacat=0

- Original Message -
From: Nicholas Geti ng...@optonline.net
To: ProFox Email List profox@leafe.com
Cc:
Sent: Wednesday, May 23, 2012 4:34 PM
Subject: Re: Win XP Pro SP1 Version 2002

I have seen some pretty well-scratched CDs that still worked. Do you have
another CD drive to test? Or another PC?

- Original Message -
From: Ajoy Khaund akha...@gmail.com
To: profox@leafe.com
Sent: Wednesday, May 23, 2012 2:03 PM
Subject: Re: Win XP Pro SP1 Version 2002

Kurt you are right.

The WinXp CD which I have is original. I had no problem for the last 8
years. I must
have used it three times or so. My cd drive is about 12 years old so that
must have
spoilt the CD with use.

If I had a pirated XP CD I would not have asked in this forum of which I
have been a member
for quite a no. of years.

Anyway no hard feelings I hope.

Thanks

On Wed, May 23, 2012 at 8:47 PM, Kurt Wendt kurtwe...@waitex.com
wrote:

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti
Sent: Tuesday, May 22, 2012 10:26 PM

Oh, I knew alright. I am amazed that this fellow said it explicitly. I
am
not about to send him any help.

- Original Message -
From: Kurt Wendt kurtwe...@waitex.com
To: ProFox Email List profox@leafe.com

Nicholas - you really don't know?

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Nicholas Geti

Are you needing a Windows Recovery CD or the Foxpro CD?
Do you mean everyone there is stealing the software?

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAPs4RvWJMgnsq7QAZc=xnjf9sccfmhjgciec8ksjsivf7+g...@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: Win XP Pro SP1 Version 2002

2012-05-22 Thread Ajoy Khaund

Thanks I needed a 32 bit version.
I have a win7 laptop so work has not halted. I need the
desktop for serial port application checking.

I am also searching the net to download on image but
not sure where to download from.

On Tue, May 22, 2012 at 8:25 PM, Kurt Wendt kurtwe...@waitex.com wrote:

Hey there Ajoy,

Sorry to hear about your dilemma. The one option is if you can get ahold
of a CD Image - and using that Image - you can burn it onto a new CD to
create an install CD.

Although - I am not sure if I can actually help you out with that. In
fact, I own XP Pro - but, I have the 64-bit version, which is probably
NOT what you have. Am I right?

Also - I don't really know how to generate a CD image. But, maybe if you
did a search on the Net for a CD Image of what you are looking for -
maybe you can get some hits.

Sorry I can't be more helpful...

-K-

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Ajoy Khaund
Sent: Tuesday, May 22, 2012 9:41 AM

Hi,

My Win XP system crashed and when I tried to reinstall the CD seems to
be
corrupt as it
appears scratched. I do not have back up CD as I had tried once to copy
it
but got some
error so left it at that. From the internet I have found out that I need
the same version for
the product key to work.

Where can I download the same? Over here very few people buy original
software so as
far as I know no one who I know in my vicinity will have such a cd.

Anything will help. Microsoft helpline curtly said that its a dead
product
and they do not have
a copy of the media available which I can use.

--
Regards,

Ajoy Khaund

Walking on water and developing software from a specification are easy
if
both are frozen.
- Edward V. Berard, Life-Cycle Approaches

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAPs4RvX_2sU1gOU1kuRxTTPgVz5xkXNnQUjb2Q=oMGssUkzi=q...@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: Win XP Pro SP1 Version 2002

2012-05-22 Thread Ajoy Khaund

The PC wont start so restoring was not possible.

Thanks

On Wed, May 23, 2012 at 1:16 AM, Michael Madigan mmadi10...@yahoo.comwrote:

Have you tried a restore to an earlier restore point?

- Original Message -
From: Kurt Wendt kurtwe...@waitex.com
To: profox@leafe.com
Cc:
Sent: Tuesday, May 22, 2012 10:55 AM
Subject: RE: Win XP Pro SP1 Version 2002

Hey there Ajoy,

Sorry to hear about your dilemma. The one option is if you can get ahold
of a CD Image - and using that Image - you can burn it onto a new CD to
create an install CD.

Although - I am not sure if I can actually help you out with that. In
fact, I own XP Pro - but, I have the 64-bit version, which is probably
NOT what you have. Am I right?

Also - I don't really know how to generate a CD image. But, maybe if you
did a search on the Net for a CD Image of what you are looking for -
maybe you can get some hits.

Sorry I can't be more helpful...

-K-

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Ajoy Khaund
Sent: Tuesday, May 22, 2012 9:41 AM

Hi,

Where can I download the same? Over here very few people buy original
software so as
far as I know no one who I know in my vicinity will have such a cd.

Anything will help. Microsoft helpline curtly said that its a dead
product
and they do not have
a copy of the media available which I can use.

--
Regards,

Ajoy Khaund

Walking on water and developing software from a specification are easy
if
both are frozen.
- Edward V. Berard, Life-Cycle Approaches

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAPs4RvVEUhzD5gTfe2zWhK3KxYfohW-x6ayZ=qmkkwbra-y...@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: Win XP Pro SP1 Version 2002

2012-05-22 Thread Ajoy Khaund

I need a Win XP Pro with sp1 Version 2002 image.

I have a XP Pro with Sp3 image but my key does
not work with that. You need the same version.

On Wed, May 23, 2012 at 1:54 AM, Nicholas Geti ng...@optonline.net wrote:

Are you needing a Windows Recovery CD or the Foxpro CD?
Do you mean everyone there is stealing the software?

- Original Message -
From: Ajoy Khaund akha...@gmail.com
To: Profox profox@leafe.com
Sent: Tuesday, May 22, 2012 9:41 AM
Subject: Win XP Pro SP1 Version 2002

Hi,

My Win XP system crashed and when I tried to reinstall the CD seems to be
corrupt as it
appears scratched. I do not have back up CD as I had tried once to copy
it
but got some
error so left it at that. From the internet I have found out that I need
the same version for
the product key to work.

Where can I download the same? Over here very few people buy original
software so as
far as I know no one who I know in my vicinity will have such a cd.

Anything will help. Microsoft helpline curtly said that its a dead
product
and they do not have
a copy of the media available which I can use.

--
Regards,

Ajoy Khaund
Neamati Road
Bhogdoi Mukh
Jorhat 785001
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy
if
both are frozen.
- Edward V. Berard, Life-Cycle Approaches

--- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAPs4RvXSKDY-=f73qnufmqf2zauwckj4jdkrvw-gs07xvcs...@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: Rounding DOWN

2012-01-26 Thread Ajoy Khaund

Here you can multiply by 100
Take INT value
Divide by 100

So 1.9256*100 = 192.56
INT(192.56) = 192
192/100 = 1.92

Christ wrote something about negative nos.
That you will have to decide with a IF  0


--
From: Sytze de Boer sytze.k...@gmail.com
Sent: Thursday, January 26, 2012 2:29 AM
To: profoxt...@leafe.com
Subject: Rounding DOWN

 Hi Folk

 What is the best way systems round Down ?
 e.g.
 1.9256 to 1.92
 5.565 to 5.56
 4.449 to 4.44

 -- 
 Regards
 Sytze de Boer


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/584D09A7FEA44DC595B54A97DED94B10@ajoykcompaq
** 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: Cursor Adapter in DE Question

2011-10-13 Thread Ajoy Khaund

Thanks
Let me go through it and I will get back to you. It looks wonderful.

Ajoy Khaund


--
From: Rafael Copquin rcopq...@fibertel.com.ar
Sent: Thursday, October 13, 2011 5:50 PM
To: profoxt...@leafe.com
Subject: Re: Cursor Adapter in DE Question

 As requested, below are the methods necessary to create a cursor adapter
 on the fly

 use thus:

 thisform.makeadapter('customers','curCustomers',[select * from customers])

 As for authentication, I use SQL Server authentication

 Connect through ODBC

 local cConnString

 cConnString=[DRIVER=SQL Server Native Client
 10.0;SERVER=MAINSERVER\SQLEXPRESS;UID=sa;PWD=12345;APP=Microsoft Visual
 FoxPro;WSID=INVOICINGPC;DATABASE=TESTDATABASE;LANGUAGE=English;]

 thisform.nHandle = SQLStringConnect(cConnString )

 BTW don't ever use the master data, you could screw things up badly.
 Just create a test database, put some tables in it, fill them with data
 and go on.

 I strongly advise you to read the books from Hentzenwerke, Megafox,
 Internet Applications. etc. That's where you get all the information
 you need

 Rafael Copquin

 ** makeadapter method
 Lparameters tcTable,tcAlias,tcCmd

 Local cSCH,cUFL,cUNL,cCmd

 thisform.lOK = .T.

 thisform.structure(tcTable)

 cUFL = Thisform.cUFL  updatable field list
 cUNL = Thisform.cUNL  update name list
 cSCH = Thisform.cSCH  table schema
 cCmd = tcCmd

 thisform.lOK = .T.

 Try

 Use in Select(tcAlias)

 If PemStatus(this,'oCA',5) = .T.
 Removeproperty(Thisform,oCA)
 Endif

 This.AddProperty(oCA)
 This.oCA = Createobject(cursoradapter)

 Catch To oErrors

 Messagebox( CursorAdapter object generation failed+;
 Chr(13)+oErrors.Message,16,Attention,2000)

 thisform.lOK = .F.

 Finally
 Endtry

 If thisform.lOK = .F.
 Return
 Endif


 If thisform.lOK = .T.
 Try

 With Thisform.oCA
 .DataSourceType = ODBC
 .DataSource = thisform.nHandle
 .Alias= tcAlias
 .Tables  = tcTabla
 .BufferModeOverride = 5
 .KeyFieldList= thisform.cKeyField
 .SendUpdates = .t.
 .usetransactions= .f.  when set to .F., the CA does
 not use transactions so you must set transactions to manual in the SQL
 Server
 .SelectCmd = cCmd
 .UpdatableFieldList = cUFL
 .UpdateNameList= cUNL
 .CursorSchema= cSCH
 .CursorFill()
 Endwith

Select (thisform.oCA.alias)

 Catch To oErrors

messagebox(Cursor generation
 failed+Chr(13)+oErrors.Message,16,'Attention')

 thisform.lOK = .F.

 Endtry
 Endif

 return

 **
 **structure method

 lparameter cTable

 Local cSch,cUNL,cUFL,cField,N

 Store '' to cSch,cUNL,cUFL
 Store 0 to nResult

 thisform.cKeyField = thisform.getkeyfield(cTable)

 ** this is the VFP cursor structure generated when data from SQL Server
 brought back

 SQLColumns(thisform.nHandle,cTable,[FOXPRO],'curStructure')


 Select curStructure

 Scan all

cUNL = cUNL + field_name+[ ]+JustStem(cTable)+[.]+field_name+[,]
cUFL = cUFL + field_name+[,]

cSCH = cSCH + field_name+[ ]+field_type

Do case
   Case InList(field_type,[C],[D],[I],[T])
cSCH = cSCH + [(] +Transform(field_len) +[)]
   Case field_type = [N]
cSCH = cSCH + [(]
 +Transform(field_len)+[,]+Transform(field_dec) +[)]
   Case field_type = [M]
cSCH = cSCH + [(] +Transform(8000) +[)]
EndCase
cSCH = cSCH + [,]


 EndScan
 Use in Select('curStructure')

 ** remove comma from end of strings

 thisform.cSCH = Substr(cSCH,1,Len(Alltrim(cSCH))-1)  schema
 thisform.cUNL = Substr(cUNL,1,Len(Alltrim(cUNL))-1)  updatenamelist
 thisform.cUFL  = Substr(cUFL,1,Len(Alltrim(cUFL))-1)  updatablefieldlist

 return

 ***
 **getkeyfield method

 lparameters cTable

 Local cField,N,cKeyField

 Use in Select('curStructure')

 ** this allows you to know what is the key field directly from the SQL
 Server data

 SQLColumns(thisform.nHandle,cTable,[NATIVE],'curStructure')

 Select curStructure


 Locate for Lower(Alltrim(type_name)) ='int identity'
 If Found()
cKeyField = Alltrim(column_name)
 EndIf

 Use in Select('curStructure')

 Return cKeyField



 El 13/10/2011 1:24, Ajoy Khaund escribió:
 Rafael,

 Are you using Windows or SQL Server Authentication?
 How are you connecting to the SQL Server data in the main form?

 Currently I am trying out with the master data which seems to be working.
 Can you send me an example of
 building CA in code. Currently I have saved a class for each table that I 
 am
 working with.

 Thanks

 Ajoy Khaund
 akha...@hotmail.com




[excessive quoting removed

Re: Cursor Adapter in DE Question

2011-10-12 Thread Ajoy Khaund

Rafael,

Are you using Windows or SQL Server Authentication?
How are you connecting to the SQL Server data in the main form?

Currently I am trying out with the master data which seems to be working. 
Can you send me an example of
building CA in code. Currently I have saved a class for each table that I am 
working with.

Thanks

Ajoy Khaund
akha...@hotmail.com


--
From: Rafael Copquin rcopq...@fibertel.com.ar
Sent: Wednesday, October 12, 2011 7:46 PM
To: profoxt...@leafe.com
Subject: Re: Cursor Adapter in DE Question

 Running the risk of overkill in this matter, I use CA's assiduously in
 all my apps, but always in code, not the wizard. Even in client/server
 situations, CA's are great, simply because you can insert, delete or
 modify your CA cursor as any regular VFP cursor and then, with a simple
 tableupdate you get the underlying tables updated. With SPT you have to
 code with the slight modifications demanded by T-SQL, which in some
 cases is different from VFP syntax. A bit of extra work and care.

 I developed a series of classes that build CA's in code by simply
 passing parameters to the class and coding is much faster that way.

 In any case, you can use a combination of SPT and CA's in the same
 routine and both will work just as well. I guess it is a matter of
 choice or oportunity.

 Rafael Copquin


 El 12/10/2011 4:17, Dave Crozier escribió:
 Rafael,
 Well that is the way I normally do things i.e entirely in code and using 
 SPT but I thought I'd just take a dip in to see if it would save time 
 Seemingly not, so I'll just recode everything using my normal Data Access 
 Components...

 Thanks for the reply. As they say, if we don't try these new things we'll 
 never know how good or bad they are.

 Dave


 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf Of Rafael Copquin
 Sent: 11 October 2011 17:07
 To: profox@leafe.com
 Subject: Re: Cursor Adapter in DE Question

 It is a better way of doing things, to do your CA's in code and not in
 the DE. You have greater control, especially if your select statement
 involves more than one table. If you use the DE CA you would have to
 change the select statement manually, because the wizard can only create
 a select of just one table efficiently ( I mean, adding the joins 
 properly)

 Another thing you might consider, is not to use relations at all but sql
 select statements to get the child table, based on the primary key of
 the father table that has a correspondence in the child table as a
 foreign key. IOW, get the primary key of the record in the father table,
 then issue a select statement to get the child records based on that key
 which should be the foreign key in the child.

 ie  nPK = fathertable.pkfield

 select * from childtable where foreingkeyfield = nPK

 So every time you refresh your CA (you can use requery(), just like a
 view ), get the PK of the record you just obtained, and use a select
 statement as above to get your child records.

 BTW, your child could be another CA or just a non-CA cursor, as you
 explained

 The other thing that comes to mind is that the only way I find CA's
 benefitial in a situation as the one you describe is when you need to
 update the underlying table, otherwise, simple SPT statements would do
 just fine.

 Rafael Copquin


 El 11/10/2011 12:41, Dave Crozier escribió:
 Not having used cursor adapters very much and wanting to try them as a 
 short cut to make the conversion of a suite of programs into Client 
 server I have the following Question.

 I have a parent table which I can pick up in the cursoradapter modifying 
 the SelectCmd property and then issuing a CursorFill method no problem, 
 the parent table refreshes itself OK and reflecs this in the form.

 However, when I add a child table that is NOT a cursor adapter but a VFP 
 table and then set up the relationship in the DE as you would with 
 standard VFP tables using a dragged link between the parent and child, 
 then when I Refill the parent table, the child doesn't reposition 
 itself as per the relationship. Its just as though the relationship 
 needs to be refreshed, but you can't refresh a relationship!!!


 Any Ideas this is driving me mad and I wish I'd stayed with SPT 
 throughout, but using adapters would save so much recoding...


 Dave C


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/E3756158ACD146539FB50A18CE0570FC@ajoykcompaq
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added

Composite Key in Sql Server 2008

2011-09-21 Thread Ajoy Khaund

Hi,

I have a composite key in VFP like

Padl(empno,4,'0') + DTOS(kdate) + Str(shiftno,1)

I use this index to do a seek to find out if a record exists for a particular 
employee on a particular date in a particular shift.

How can I do that in sql. I am going to use cursor adaptors.

TIA

Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Cell: +91-9435092287
Fixed: +91-376-2351288
Mail: akha...@hotmail.com
Blog: http://teaanalyst.blogspot.com/
Downloads: http://cid-40c8c3127198e7ff.skydrive.live.com/browse.aspx/Public


Walking on water and developing software from a specification are easy if both 
are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/F23BDBF052A642E4B8035BA0BE0F5E37@ajoykcompaq
** 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: Composite Key in Sql Server 2008

2011-09-21 Thread Ajoy Khaund

Thanks.
I have a transactions table where before doing an entry I check if that 
record exists by empno + date + shiftno. If the seek fails I add the records 
else I overwrite existing records. Maybe in SQL server we have to do it 
slightly differently.

--
From: Stephen Russell srussell...@gmail.com
Sent: Wednesday, September 21, 2011 6:24 PM
To: profoxt...@leafe.com
Subject: Re: Composite Key in Sql Server 2008

 On Wed, Sep 21, 2011 at 7:37 AM, Ajoy Khaund akha...@gmail.com wrote:
 Hi,

 I have a composite key in VFP like

 Padl(empno,4,'0') + DTOS(kdate) + Str(shiftno,1)

 I use this index to do a seek to find out if a record exists for a 
 particular employee on a particular date in a particular shift.

 How can I do that in sql. I am going to use cursor adaptors.

 -

 Do you know how to create indexs in SQL Server tables that span
 multiple columns?

 CREATE UNIQUE NONCLUSTERED INDEX newKey ON YourTable
 (
 empNumber,
 kDate,
 shiftNo
 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
 ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 GO

 In your where clause :
 Where empNumber = YourmakeshiftValue
 and kDatebetween StartOfDay and EndOfDay
 and shftno = 1

 As a heads up.  This index may never get used  if the table is joined
 so all of this is mute.

 -- 
 Stephen Russell

 Unified Health Services
 60 Germantown Court
 Suite 220
 Cordova, TN 38018

 Telephone: 888.510.2667

 901.246-0159 cell

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/7572B5A7801D405DA3B483F240409EC9@ajoykcompaq
** 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: Composite Key in Sql Server 2008

2011-09-21 Thread Ajoy Khaund

@Stephen: SQL Server 2008 has a date field. Would that also keep the time 
portion internally.

If I have to run a sql command to find if a record exists that's also fine 
by me becoz. I suppose that query will be very fast compared to VFP.


--
From: Grigore Dolghin gdolg...@gmail.com
Sent: Wednesday, September 21, 2011 6:52 PM
To: profoxt...@leafe.com
Subject: Re: Composite Key in Sql Server 2008

 I would create three indexes, one for each column, and use a WHERE
 clause in SELECT, similar to this one:

 WHERE empno = ?m.empno AND kdate = ?m.kdate AND shiftno = ?m.shiftno

 Note: using functions in expressions used in where is a performance
 killer because those functions get evaluated for each and every
 record. Index the columns and use WHERE properly. Character columns
 should be defined as VARCHAR(n) and make sure no extra spaces go to
 server with the actual values. In VFP this could be easily
 accomplished by using SET VARCHARMAPPING. There's one more issue which
 you may need to take care of: the ThisForm.txtName.Value expression
 contains extra spaces at the end, which need to be trimmed out. This
 could be done programatically, before sending the values to server, or
 directly from the interface, by setting the Format property to F.

 Hope this helps.

 On Wed, Sep 21, 2011 at 3:54 PM, Stephen Russell srussell...@gmail.com 
 wrote:
 On Wed, Sep 21, 2011 at 7:37 AM, Ajoy Khaund akha...@gmail.com wrote:
 Hi,

 I have a composite key in VFP like

 Padl(empno,4,'0') + DTOS(kdate) + Str(shiftno,1)

 I use this index to do a seek to find out if a record exists for a 
 particular employee on a particular date in a particular shift.

 How can I do that in sql. I am going to use cursor adaptors.

 -

 Do you know how to create indexs in SQL Server tables that span
 multiple columns?

 CREATE UNIQUE NONCLUSTERED INDEX newKey ON YourTable
(
empNumber,
kDate,
shiftNo
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
 ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 GO


 In your where clause :
 Where empNumber = YourmakeshiftValue
 and kDatebetween StartOfDay and EndOfDay
 and shftno = 1

 As a heads up.  This index may never get used  if the table is joined
 so all of this is mute.


 --
 Stephen Russell

 Unified Health Services
 60 Germantown Court
 Suite 220
 Cordova, TN 38018

 Telephone: 888.510.2667

 901.246-0159 cell

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/3FFBD6F30FC0483687179E1DD9D79D39@ajoykcompaq
** 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.

Copying SQL Data from one m/c to another

2011-08-27 Thread Ajoy Khaund

Hi,

If SQL Server Express Edition is installed in two computers, then can I just 
copy the data folder from the first machine and paste it to the second machine.
Is that possible or is it something completely different?

TIA

Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Cell: +91-9435092287
Fixed: +91-376-2351288
Mail: akha...@hotmail.com
Blog: http://teaanalyst.blogspot.com/
Downloads: http://cid-40c8c3127198e7ff.skydrive.live.com/browse.aspx/Public


Walking on water and developing software from a specification are easy if both 
are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/3D1E6857536A4D83A2F157DD82E7E92D@ajoykcompaq
** 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: Copying SQL Data from one m/c to another

2011-08-27 Thread Ajoy Khaund

Currently I develop desktop applications with Vfp 6  9. The data entry to 
the databases are been done by say operators in desktops. The owner 
generally has a laptop and he likes to copy the data to his laptop in the 
evening so that he can evaluate the work done so far.

Now the operators copy the data to a flash drive and gives it to the owner 
when they leave for home. Will the sql process be as easy as that or very 
different.


--
From: Stephen Russell srussell...@gmail.com
Sent: Saturday, August 27, 2011 5:43 PM
To: profoxt...@leafe.com
Subject: Re: Copying SQL Data from one m/c to another

 On Sat, Aug 27, 2011 at 5:16 AM, Ajoy Khaund akha...@gmail.com wrote:
 Hi,

 If SQL Server Express Edition is installed in two computers, then can I 
 just copy the data folder from the first machine and paste it to the 
 second machine.
 Is that possible or is it something completely different?
 -

 Read up on detach and reattach.

 There are data meta databases as well as your database.  The databases
 have an ID for the SERVER they are on
 detach will open up the ability to bring in a new server to as as the 
 host.
 -- 
 Stephen Russell

 Unified Health Services
 60 Germantown Court
 Suite 220
 Cordova, TN 38018

 Telephone: 888.510.2667

 901.246-0159 cell

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/62DA12F063B842AD8C338D943312A24F@ajoykcompaq
** 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.

Retrieve Data after pack index

2011-02-14 Thread Ajoy Khaund

Hi,

After deleting some records and issuing a PACK and then deleting the indexes 
for the table and creating the indexes again is it possible by anyone to 
retrieve the deleted the data. Is there any software by which someone will be 
able to retrieve the data. Any kind of information will help. Sometimes some 
people ask these questions and I am at a loss of words. If any software can 
recover it please let me know.

Currently what I am telling them that's its not possible  that its something 
like you have an excel sheet of say 100 rows. You then delete 20 rows and save 
it. After saving whether it possible to recover the deleted rows??

Thanks in advance.

Bobby

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bay151-ds21d90f8e6c26ee15acd26bb3...@phx.gbl
** 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: Retrieve Data after pack index

2011-02-14 Thread Ajoy Khaund

Hey Ted thanks I have noted your points.

--
From: Ted Roche tedro...@gmail.com
Sent: Tuesday, February 15, 2011 7:29 AM
To: profoxt...@leafe.com
Subject: Re: Retrieve Data after pack  index

 On Mon, Feb 14, 2011 at 8:17 PM, Ajoy Khaund akha...@hotmail.com wrote:

 After deleting some records and issuing a PACK and then deleting the 
 indexes for the table and creating the indexes again is it possible by 
 anyone to retrieve the deleted the data. Is there any software by which 
 someone will be able to retrieve the data. Any kind of information will 
 help. Sometimes some people ask these questions and I am at a loss of 
 words. If any software can recover it please let me know.

 Anyone? Like the NSA?

 Yes. If you're trying to keep secrets from people, you shouldn't keep
 them on computers. There are ways your disk image could be seized and
 the temp files used in the PACK and then deleted could be recovered
 and read. Browse around in the temp directories. But that's not all
 that likely.

 If you're keeping your data on a network storage device, it may make
 backups. If you're using Windows, it may store your files in a restore
 point.

 Realize that anything entered into a computer might show up at the
 worst possible moment. You regularly hear about scandals where someone
 thought the email they deleted was gone forever. That's naive.

 Do you make backups? Don't forget to shred them. And burn the bits.

 There are ways to prevent, or mitigate all of these risks, but you
 need to be careful about your answers there. If it's the company's
 price list, which all their customers already know, perhaps a PACK is
 sufficient. But if it's information that could cost peoples their
 lives or livelihoods

 Currently what I am telling them that's its not possible  that its 
 something like you have an excel sheet of say 100 rows. You then delete 
 20 rows and save it. After saving whether it possible to recover the 
 deleted rows??

 Well, that's pretty unlikely. Sometimes Excel stores stuff in its
 spare spaces. I still wouldn't keep my secrets on it.

 -- 
 Ted Roche
 Ted Roche  Associates, LLC
 http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5CA48AAB93D546F283F16AC414BA3959@ajoykcompaq
** 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.

CM Table Repair Utility

2010-07-22 Thread Ajoy Khaund

Hi All,

Is anyone using this utility with the apps.? I am having a lot of support calls 
where table headers are corrupted as clients are using the apps even on 
secondary power as a result of which tables are getting corrupted.

TIA

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/9df71241cf354215930c3a5746e09...@compaq
** 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.

Sqlserver 2005 or 2008

2010-06-26 Thread Ajoy Khaund

Hi,

I did some testing in sqlserver in dec 2009 and am finding some time again
to look into it as a backend. Since I am starting new should I go for
sqlserver 2008 ?

How are you all keeping a date field like birthdate or hiredate in 2005. Are
you all keeping it in text format or smalldatetime ? I saw somewhere the
version 2008 has a date field.

Thanks for any advice.

-- 
Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktilbx5dqrc2ccv0ha1qopn8qt2hrk-l_1xclk...@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] What do I need?

2010-05-31 Thread Ajoy Khaund

Hi,

I just wanted to know if you use a wireless router (say wired from router to 
desktop  wireless to laptop) will also work like a switch to share files. I 
had a desktop for nearly 10 years and now I have a laptop also. I can use a 
wireless modem to share the internet but that wont allow me to share files I 
suppose. Will a router do that or do I have to buy a switch along with the 
router. My laptop has a N series 5 GHz wireless card which will work in dual 
band also. So I am looking for a dual  band wireless router.

Thanks

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Ted Roche tedro...@gmail.com
Sent: Monday, May 31, 2010 6:25 PM
To: profoxt...@leafe.com
Subject: Re: [NF] What do I need?

 On Sun, May 30, 2010 at 9:34 PM, Joel N. Fischoff petru...@rcn.com 
 wrote:

 So, what do I need?  Right now, I'm thinking that all I really need is a
 wired router connected to the modem and the three computers.

 Do you have any recommendations for what I should pick up?


 It depends on what you want to do. If you want to be able to pick up
 your laptop and take it out on the porch to enjoy the breeze, you'll
 want wifi. Which adapter (802.11b, g, or n) the laptop has determines
 what you need. If you don't want to run cables all over the place, you
 can do it all wirelessly these days. My preference is to wire the
 stationary items (desktop 'puter, printers) and use wireless for the
 laptops. However, our needs seem to be greater than yours - three
 levels of computers, mobile laptops, business home office, etc.

 I'm a big fan of print servers for the printers, to remove the
 requirement that the associated computer be running in order to print.

 If it's compatible with your needs, the D-Link DIR-655 is a bargain.



 -- 
 Ted Roche
 Ted Roche  Associates, LLC
 http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/148c0adcbe264e4684e6c84e034d4...@compaq
** 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: Problem building EXE

2010-05-31 Thread Ajoy Khaund

I had a similar problem on win7 but finally I saw it was Kaspersky Internet
Security which was causing the problem. I changed settings in KIS2010 and
then the issue disappeared.

Ajoy Khaund

On Tue, Jun 1, 2010 at 10:27 AM, Sytze de Boer sytze.k...@gmail.com wrote:

 I've had this in the past but on 2nd try, it normally comes right so I've
 not worried about it.
 This time however, I can't get it to work

 When I type MODI PROJECT MYAPP, it goes through the normal process and I
 can
 see it rebuilding etc as it flashes past.
 I have a tick in
 Win32 Executable
 Recompile all files
 Display errors
 Regenerate Component ID's

 Right at the end it when you'd expect it to come up and say Completed, it
 comes up with a messagebox
 that says 'File is not open'.
 and my applicatio has not been created
 I've now tried this 20 plus time.

 Can anyone throw some light on this?


 --
 Regards
 Sytze de Boer
 Kiss Systems
 Hamilton, NZ
 Ph: 64-7-8391670, Mob:64 21 937611
 URL: www.kiss.co.nz


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktikcndk4hndyyz_n1ytmwpnkn-cjvauylky5o...@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.

Install Vfp6 on a Win7 Home Premium Laptop

2010-02-27 Thread Ajoy Khaund

Hi,

Just purchased a laptop with Win7 Home Premium. I have installed Vfp9. Now
when I put in the Visual Studio 6 cd it wants to update Microsoft Java
Virtual Machine. Is it okay to update that. I hope its not a very dumb
question. In XP I did not have any problem with it.

TIA

-- 
Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3591002270740v45f43fe3q4313898fc9f9f...@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: Install Vfp6 on a Win7 Home Premium Laptop

2010-02-27 Thread Ajoy Khaund

Thanks Dave.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Dave Crozier da...@replacement-software.co.uk
Sent: Saturday, February 27, 2010 11:03 PM
To: profoxt...@leafe.com
Subject: RE: Install Vfp6 on a Win7 Home Premium Laptop

 Ajoy,
 NO problem at all as Studio needs a Java VM. Just make sure you look at 
 the
 installation options carefully or uyou'll end up with open office 
 installed
 and a nes search engine toolbar. They are obvious to ignore as long as you
 read rather than jost click OK!

 Dave Crozier
 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
 Of Ajoy Khaund
 Sent: 27 February 2010 15:41
 To: Profox
 Subject: Install Vfp6 on a Win7 Home Premium Laptop

 Hi,

 Just purchased a laptop with Win7 Home Premium. I have installed Vfp9. Now
 when I put in the Visual Studio 6 cd it wants to update Microsoft Java
 Virtual Machine. Is it okay to update that. I hope its not a very dumb
 question. In XP I did not have any problem with it.

 TIA

 -- 
 Regards,

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com
 http://teaanalyst.blogspot.com/


 Walking on water and developing software from a specification are easy if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bad0250e7ca64cc79d9f56da1df7f...@compaq
** 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: Install Vfp6 on a Win7 Home Premium Laptop

2010-02-27 Thread Ajoy Khaund

Dave,

I have installed Vfp6 successfully but I am unable to install SP5 as mdac2.6 
just wont install. Is there any workaround like copy the entire vfp98 
directory from the SP5 cd. I have read that 64 bit versions do not support 
the jet database components or something like that.

Thanks


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Dave Crozier da...@replacement-software.co.uk
Sent: Saturday, February 27, 2010 11:03 PM
To: profoxt...@leafe.com
Subject: RE: Install Vfp6 on a Win7 Home Premium Laptop

 Ajoy,
 NO problem at all as Studio needs a Java VM. Just make sure you look at 
 the
 installation options carefully or uyou'll end up with open office 
 installed
 and a nes search engine toolbar. They are obvious to ignore as long as you
 read rather than jost click OK!

 Dave Crozier
 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
 Of Ajoy Khaund
 Sent: 27 February 2010 15:41
 To: Profox
 Subject: Install Vfp6 on a Win7 Home Premium Laptop

 Hi,

 Just purchased a laptop with Win7 Home Premium. I have installed Vfp9. Now
 when I put in the Visual Studio 6 cd it wants to update Microsoft Java
 Virtual Machine. Is it okay to update that. I hope its not a very dumb
 question. In XP I did not have any problem with it.

 TIA

 -- 
 Regards,

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com
 http://teaanalyst.blogspot.com/


 Walking on water and developing software from a specification are easy if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/c086b7958a4d414a8ac3083f7334e...@compaq
** 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: Data reading problem from a fingerprint reader through Ocx

2010-02-11 Thread Ajoy Khaund

Hi

I have a weigh bridge app where I have set a timer which will keep checking 
if the weight has changed and refresh it.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: na...@syedjunaidalam.com
Sent: Wednesday, February 10, 2010 10:32 AM
To: profoxt...@leafe.com
Subject: Data reading problem from a fingerprint reader through Ocx

 Hi,

 I recently deployed a biometric fingerprint reader for time attendance.
 The local supplier gave us an ocx written in VB so that I can communicate
 with the device in real time. This device is on our LAN and I can connect
 it through its local IP and port number.

 This ocx is working fine in VB for real time event handling. But in VFP 7
 and VFP 9, sometime it does not capture the real time event properly. If I
 minimize and maximize my program's main window then it captures and shows
 the event data on screen.

 Why Foxpro hangs while reading the data from the device and refreshes when
 I manually minimize and maximize the program?

 TIA

 Naeem


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/b9da28d66a4c4ee7a20697bd60cf0...@compaq
** 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: VFP9-Ideas

2010-01-12 Thread Ajoy Khaund

Styze,

do u have a evaluation version of your software?  I would like to go through 
it.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Sytze de Boer sytze.k...@gmail.com
Sent: Tuesday, January 12, 2010 1:13 AM
To: profoxt...@leafe.com
Subject: VFP9-Ideas

 Hi folk
 I update many hundreds of clients during March with my accounting system
 program.
 (Accounts receivable, accounts payable, general ledger and payroll)

 Last year I added a new feature that was received with huge enthusiasm.
 (TXTing from within the system, a client, supplier, employee or ad hoc)

 I need another killer idea for this year.
 Just a small module.
 Does anyone have any ideas?


 -- 
 Regards
 Sytze de Boer
 Kiss Systems
 Hamilton, NZ
 Ph: 64-7-8391670, Mob:64 21 937611
 URL: www.kiss.co.nz


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/627dc5d106694f38955f4b7f3918f...@compaq
** 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.

Previewing thru XFRX

2010-01-07 Thread Ajoy Khaund

Hi,

I have just purchased XFRX and trying to use it in my current setup.

Currently I have a base form and a report previewer form. My main form is a Top 
level form. In my base from I have a method which accepts a report name and I 
have the following code there to preview the report.

Lparameters tcRepName
tcForm = TaReportPreview

Local loForm
loForm = NEWOBJECT(tcForm,'akform.vcx')
With loForm
 .NAME = loForm  Must use 'loForm' else it gives error
 Keyboard {ctrl+f10}
 .VISIBLE = .T.
Endwith

Report FORM tcRepName PREVIEW WINDOW loForm

Return .T.

1 Now without having to change the syntax of calling this form how do I 
incorporate code inside this method to call the XFRX previewer.

2 I have tried to put the cntXFRXMultiPage container on this reportpreview 
form. Its working but the toolbar goes below screen limits and the preview does 
not center.

Any help will do. I am send this ti Martin also.




Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/fadb8dd452a6428f9211b0b042fcd...@compaq
** 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: Happy New Year from Jorhat, India

2010-01-04 Thread Ajoy Khaund

Pete,

A bit delay in replying. China is not very far. I wont know how many miles 
as the China border is near the state of Arunachal Pradesh and I have not 
gone that side at all.

I will try to find out and update you. Maybe atleast 12 hours drive from my 
place. That's a wild guess.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Pete Theisen petethei...@verizon.net
Sent: Friday, January 01, 2010 10:33 AM
To: profoxt...@leafe.com
Subject: Re: Happy New Year from Jorhat, India

 Ajoy Khaund wrote:

 Wishing you all a Very Happy and Prosperous 2010.

 Best wishes to you all for the coming season.


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com
 http://teaanalyst.blogspot.com/

 Walking on water and developing software from a specification are easy 
 if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 Hi Ajoy,

 How far from China? Only a quarter inch on the map, but that could be
 anything.

 -- 
 Regards,

 Pete
 http://pete-theisen.com/
 http://elect-pete-theisen.com/

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/6756bbb8cf634bb986f928b33372c...@compaq
** 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.

Happy New Year from Jorhat, India

2009-12-31 Thread Ajoy Khaund

Hi All,

Wishing you all a Very Happy and Prosperous 2010.

Best wishes to you all for the coming season.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0731de11aadb4bdd8e23a5f61eaa3...@compaq
** 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.

Rich Text Control + Report

2009-11-09 Thread Ajoy Khaund

Hi,

I am using a Rich Text Control to input data to a report and then the data from 
the memo field is converted to a GEN field and connected to a active-x control 
in a frx.
Now in the form where I have the control say the length of a text line is 7 
inches. In the report the line gets wrapped at say 5 inches.

The width of the control is 7.5 inches so space is not a problem.

TIA

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/3fdfa19c124f440bad6804fd1397b...@compaq
** 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: Rich Text Control + Report

2009-11-09 Thread Ajoy Khaund

Its not that. I have to tweak it some where. Before i do the preview if I 
browse the cursor and open the general field the every 7.5 inch lines have 
become
5.5 inch on odd lines and say 2 inch on even lines. So if I double click on 
the output from the general field the lines all become 7.5 inchs.

Then if I close and gen the frx its okay.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Allen pro...@gatwicksoftware.com
Sent: Monday, November 09, 2009 5:54 PM
To: profoxt...@leafe.com
Subject: RE: Rich Text Control + Report

 There is a right margin on the control maybe that was it.
 Al

 -Original Message-

 I am using a Rich Text Control to input data to a report and then the data
 from the memo field is converted to a GEN field and connected to a 
 active-x
 control in a frx.
 Now in the form where I have the control say the length of a text line is 
 7
 inches. In the report the line gets wrapped at say 5 inches.

 The width of the control is 7.5 inches so space is not a problem.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/59d849d3b1474f3f8e5563bcb7a0c...@compaq
** 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: Rich Text Control + Report

2009-11-09 Thread Ajoy Khaund

The output goes to a word document before getting appended to the general 
field. Word by default gives me a layout of 6 inches with a left margin of 
1.25 and a right margin of 1.25 inches. So I have to get the default word 
document margins correct. I wonder if I can set the one which gets created 
temporarily or I have to keep a template.

Let me work on that. Thanks for getting me thinking. It's a step forward.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Allen pro...@gatwicksoftware.com
Sent: Monday, November 09, 2009 5:54 PM
To: profoxt...@leafe.com
Subject: RE: Rich Text Control + Report

 There is a right margin on the control maybe that was it.
 Al

 -Original Message-

 I am using a Rich Text Control to input data to a report and then the data
 from the memo field is converted to a GEN field and connected to a 
 active-x
 control in a frx.
 Now in the form where I have the control say the length of a text line is 
 7
 inches. In the report the line gets wrapped at say 5 inches.

 The width of the control is 7.5 inches so space is not a problem.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1890d0086abd43ee962560952cf6e...@compaq
** 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: Strange Data Corruption Issue

2009-10-29 Thread Ajoy Khaund

Ok

How do you disable disable write-behind caching on local and network drives 
?



Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: MB Software Solutions,LLC 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, October 29, 2009 11:21 AM
To: profoxt...@leafe.com
Subject: Re: Strange Data Corruption Issue

 Ajoy Khaund wrote:
 Hey Michael,

 Can I have a copy of your best practices document if its not 
 confidential.

 That sounds like a good idea to give clients.

 Well, I can't give you the official day-time gig document, but let me
 just sum it up:

 - use a UPS (uninterrupted power supply) to guard against data
 loss/corruption due to power fluctuation
 - make backups daily (our software has its own backup mechanism)
 - run the cleanup daily (our software has its own cleanup routine for
 packing data and trying to enforce SOME sort of referential integrity)
 - configure the anti-virus software to EXCLUDE our application and data
 folders
 - disable write-behind caching on local and network drives


 -- 
 Mike Babcock, MCP
 MB Software Solutions, LLC
 President, Chief Software Architect
 http://mbsoftwaresolutions.com
 http://fabmate.com
 http://twitter.com/mbabcock16


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/afc96dfbb7124a079f9cdd51c444b...@compaq
** 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: Strange Data Corruption Issue

2009-10-28 Thread Ajoy Khaund

Hey Michael,

Can I have a copy of your best practices document if its not confidential.

That sounds like a good idea to give clients.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: MB Software Solutions,LLC 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Tuesday, October 27, 2009 7:57 PM
To: profoxt...@leafe.com
Subject: Re: Strange Data Corruption Issue

 Aida I. Rivera-Benítez wrote:
 Hi to all!

 Have a client with a strange data corruption issue.  When I went to the 
 site
 was receiving a Not a Table message.  I said to myself, piece of cake,
 just
 fix the affected table(s) or restore from a backup and go on.  But when I
 tried to
 fix the tables received another error and for the first time in more than 
 20
 years
 my fixdbf program didn't work.  Upon further inspection of the affected
 tables (8),
 noticed that the contents was not there, there were filled with spaces, 
 so
 no wonder,
 nothing to recover.

 Had to restore from a backup and that solve the problem.  Now I'm 
 wondering
 is it a
 hard disk crashing or network failure, well I don't think so, worked in 
 this
 scenario
 before and the tables either dissapear completely (files deleted) or some
 records are replaced
 or added with junk values, or is there any utility or antivirus that does
 this? so I can remove it.

 Regards.


 Hi Aida,

 In our Best Practices document here at the day-job, we advise our
 customers to exclude our program and data folders from the A/V scans.

 -- 
 Mike Babcock, MCP
 MB Software Solutions, LLC
 President, Chief Software Architect
 http://mbsoftwaresolutions.com
 http://fabmate.com
 http://twitter.com/mbabcock16


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/af59fb8e0fd5434ab0410c517c352...@compaq
** 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: Brought to you by the people who gave you IE

2009-09-29 Thread Ajoy Khaund

Yep maybe we should connect the AV when we are on the internet or something.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Paul McNett p...@ulmcnett.com
Sent: Wednesday, September 30, 2009 9:22 AM
To: profoxt...@leafe.com
Subject: Re: Brought to you by the people who gave you IE

 Ed Leafe wrote:
 On Sep 29, 2009, at 11:22 PM, MB Software Solutions General Account
 wrote:

 Saw an article the other day that suggested the virus writers are
 targeting Macs more nowadays.  Is it only a matter of time until the
 next target is Ubuntu, or is that O/S structured in such a way to be
 immune to a virus attack?


 I don't think that anyone would be naive enough to claim that any
 networked computer would be immune to an attack. But the point is
 that *nix was designed from the outset to be a networked OS, so it is
 inherently not as vulnerable as a Windows box. There are still many
 exploits that can be found in apps that can compromise the box, no
 matter what OS - even OS X or Ubuntu. It's just a much higher bar to
 clear.

 Let's also not forget that there's a big market for anti-virus and 
 anti-spyware
 software for Windows machines (and next to no market for these on Mac and 
 Linux).

 So even if the AV companies aren't directly writing exploits, it sure is 
 in their
 best interests for exploits to keep appearing, and for the image to be 
 that AV is
 necessary.

 I've been running my WinXP box for years now with no AV installed, and no 
 virus
 infections. Every now and then I run a scan of the filesystem using ClamAV 
 on Linux,
 and sure it finds some virus email attachments, but they've never been run 
 so there
 wasn't any harm done.

 I've only recently installed AV software on my client's network, because 
 of some
 minor spyware problems over the past few months. This is after over 10 
 years of them
 being on the Internet with Windows NT, 2K, and XP.

 So there's definitely hype over virus threats, but there's also some best 
 practices
 we've followed, such as having a robust perimeter firewall, not running IE 
 or
 Outlook/Outlook Express, having good spam filtering, turning off Windows 
 File and
 Print Sharing (because they are unnecessary and dangerous), not letting 
 normal users
 write to the Windows or Program Files directories (a policy I've had in 
 place the
 entire time), using secure tunnels, and also having trained, educated 
 users.

 Try turning off your background AV sometime. You may be pleasantly 
 surprised at how
 much nicer it is to work on your machine.

 Paul


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/3da85d2bfd6c443ea173e73855100...@compaq
** 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.

XFRX Text Format

2009-09-27 Thread Ajoy Khaund

Hi,

I am evaluating the demo version of XFRX. This does not have the Text output (I 
don't know why). Can anyone using XFRX send me a output of a report in text 
format. Many of my customers have dot matrix printers. I want to print a report 
and check the speed of printing. My email address is akhaund at gmail dot com.

TIA


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/05bcee8776d44884953faca3f6bc2...@compaq
** 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: vfp9sp2 image on report

2009-09-03 Thread Ajoy Khaund

hI,

Just read Cathy's reply in Foxite (Thread ID 174767).

Earlier I had appended to a general file but now it seems to be working with 
just the file name.

I wonder why I did not do this before.

Image name not there anymore.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


From: Ajoy Khaund 
Sent: Thursday, September 03, 2009 11:19 AM
To: Profox 
Subject: vfp9sp2 image on report


Hi,
I have a Payroll app where the user can print ID cards for the workers. Today 
while checking the preview of the photo (BMP) which comes in the report I have 
noticed the name of the image is also appearing in the ole control. How do I 
remove the name (say x.bmp) ? It wasn't there before. Could it be a sp2 
problem ?

TIA

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/f48eb99fad1c49b4ace31a3cead46...@compaq
** 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.

vfp9sp2 image on report

2009-09-02 Thread Ajoy Khaund

Hi,
I have a Payroll app where the user can print ID cards for the workers. Today 
while checking the preview of the photo (BMP) which comes in the report I have 
noticed the name of the image is also appearing in the ole control. How do I 
remove the name (say x.bmp) ? It wasn't there before. Could it be a sp2 
problem ?

TIA

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/7ea63b9e3c12490597b5cb5f8ce2d...@compaq
** 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.

XFRX

2009-08-17 Thread Ajoy Khaund

Hi,

XFRX hasn't released any update since dec 2008. I check their site now 
then. Would anyone know why or have any news of FRX ?

-- 
Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com
http://teaanalyst.blogspot.com/


Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3590908170503pee1fcd9oba51219a3da3a...@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.

Vfp Install Shield

2009-07-19 Thread Ajoy Khaund

Hi All,

I use Install Shield which comes with Vfp to distribute my apps. I have set
the directory as say MyAppDir. I have not specified any drive as the user
can select that.

Now what I have noticed is when the installer runs in nearly every PC it
selects a random drive to install. Say the PC has C,d,e, f. The install say
shows F:\MyAppDir. Ok I change the drive to D:\MyAppDir and do the install.
No problem. Now when the app runs mostly when I open a form with a activex
date control the installer run and creates the directory F:\MyAppDir. If I
delete it it gets created again. What am I setting wrong ?
 Not much of a problem but I find it irritating sometimes.

TIA.

-- 
Regards,

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3590907190742g44d01cc6u3d9fd4a5bffbe...@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 Install Shield

2009-07-19 Thread Ajoy Khaund

Thanks Rick. I will do that. Plus I will give Innosetup a try also if its so 
good.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rick Schummer pro...@whitelightcomputing.com
Sent: Sunday, July 19, 2009 9:26 PM
To: profoxt...@leafe.com
Subject: RE: Vfp Install Shield

 I have not specified any drive as the user can select that.

 My recommendation for you is to have INSTALLDIR (set up under the General
 Information (Step 1)) default to the standard [ProgramFilesDir]\MyAppDir, 
 or
 if you want it to something else just hardcode it. I would not leave out 
 the
 a drive. Then under the Dialogs (under step 4) make sure the Destination
 Folder dialog is set up so the user can select the folder they want to
 install it in.

 Now when the app runs mostly when I open a form with a activex date
 control the installer run and creates the directory F:\MyAppDir. If I 
 delete
 it it gets created again. What am I setting wrong ?

 Now the ActiveX control issue is a separate issue. Where is it getting
 installed? Are you using a Merge Module or are you directing the
 registration on your own via the files section?

 You have to ensure it is getting registered no matter where you choose to
 have it installed.

 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2ab780acc7994f2fbd44c359d98d1...@compaq
** 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: Ribbon menus

2009-07-11 Thread Ajoy Khaund

Is there any website where I can see what was shown in Prague ? You can also 
say it in a few lines if you don't mind.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Peter Hart ph...@peterhartcomputers.co.uk
Sent: Saturday, July 11, 2009 4:40 PM
To: profoxt...@leafe.com
Subject: RE: Ribbon menus

 Hi All



 Been asked by a client if I can update his application to make it more
 modern.   Showed him what I had seen at the Prague conference and he
 very much likes the Idea of a ribbon bar.

 Like Office 2007.  Research found the VFPX Tab menu project and the ARG
 command bars project.  Advantages and disadvantages so far are Tab Menu
 is free ARG is 120 dollars.  Tab Menu is sparse on documentation whilst
 ARG seem to be documented much better.

 I am asking for comments, suggestions and other areas to look.



 Than you



 Peter Hart

 Peter Hart Computers



 P.S. Thanks to Dave and Robbo for helping to make the Prague Experience
 so enjoyable.







 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/29a5619495d94b61ad63b3c897338...@compaq
** 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: PEM Editor 4 released...

2009-07-07 Thread Ajoy Khaund

In the installation notes a screen shot is given what to click where. A line 
with a arrow points to the app to be selected. How does one draw a line on 
top of the image. I want to do that in my help files.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Matt Slay foxst...@jordanmachine.com
Sent: Monday, July 06, 2009 8:30 PM
To: profoxt...@leafe.com
Subject: PEM Editor 4 released...

 PEM Editor Version 4 was released on 2009/07/05 as part of the VFPx 
 Project
 on CodePlex.com.

 This is a powerful VFP tool that can replace the Properties window, Edit
 Property/Method, New Property, New Method, the Document View window, and 
 has
 many other powerful features. It's hard to describe the myriad things this
 tool will do, so please check out the site and watch the videos. You'll 
 find
 that PEM Editor will bring a new level of convenience and efficiency to 
 your
 development.

 (Supports VFP8 and VFP9)

 You can see screenshots, read about the features, and watch the new video
 series here:

 http://vfpx.codeplex.com/Wiki/View.aspx?title=PEM%20Editor




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/11e731aa04fb48e2bf6afa03362a5...@compaq
** 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: PEM Editor 4 released...

2009-07-07 Thread Ajoy Khaund

Thanks Matt  Rick.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rick Schummer pro...@whitelightcomputing.com
Sent: Tuesday, July 07, 2009 8:23 PM
To: profoxt...@leafe.com
Subject: RE: PEM Editor 4 released...

In the installation notes a screen shot is given what to click where. A
 line
 with a arrow points to the app to be selected. How does one draw a line on
 top of the image. I want to do that in my help files.

 I am not sure what tool the PEM Editor documentation team used, but it is
 something simply baked into Snagit from Techsmith. Awesome tool I highly
 recommend for documentation and Help files.

 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com





[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/f225006a39ff48c39699196f9e702...@compaq
** 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: VFP9 SP1 - need to create a statement withthereportwriter-multiple trx for a single client on one page.Att:Dave Crozier

2009-06-26 Thread Ajoy Khaund

Dave,

Did you post this anywhere ? You mentioned u would before going on a trip.

I just wanted to look at it.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Dave Crozier da...@flexipol.co.uk
Sent: Wednesday, May 06, 2009 9:11 PM
To: profoxt...@leafe.com
Subject: RE: VFP9 SP1 - need to create a statement 
withthereportwriter-multiple trx for a single client on one page.Att:Dave 
Crozier

 Ajoy,
 Sorry to be a little late. I haven't forgotten, just had to put it to the
 bottom of a long pile for a couple of days unfortunately so sorry about
 that.
 Anyway, I have almost finished the write up which I'll put onto Ed's
 download page. I know Andrew was also interested.

 Should be done tonight or tomorrow.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
 Of Ajoy Khaund
 Sent: 06 May 2009 15:12
 To: Profox
 Subject: Fw: VFP9 SP1 - need to create a statement with
 thereportwriter-multiple trx for a single client on one page. Att:Dave
 Crozier

 Dave,

 Did you finally send this ? If yes can I have a copy. You might have
 overlooked. I wanted to go thru what you had done.

 Thankz


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Ajoy Khaund akha...@gmail.com
 Sent: Friday, April 24, 2009 7:08 PM
 To: profox@leafe.com
 Subject: Re: VFP9 SP1 - need to create a statement with the
 reportwriter-multiple trx for a single client on one page.

 Dave I would also be interested. Thankz


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy 
 if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Dave Crozier da...@flexipol.co.uk
 Sent: Friday, April 24, 2009 5:05 PM
 To: profoxt...@leafe.com
 Subject: RE: VFP9 SP1 - need to create a statement with the
 reportwriter-multiple trx for a single client on one page.

 Andrew,
 Will do.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
 Behalf
 Of Andrew Stirling
 Sent: 24 April 2009 12:18
 To: profox@leafe.com
 Subject: Re: VFP9 SP1 - need to create a statement with the report
 writer-multiple trx for a single client on one page.

 Dave

 Could you post the details, or perhaps put on Ed's download page.
 Thanks

 Andrew Stirling
 01250 874580
 http://www.calcpay.co.uk
 HMRC Accredited UK payroll program


 Dave Crozier wrote:
 Kam,
 I'll send you an example from our sales ledger over the weekend that
 allows
 the user to modify the reports within the system.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
 Behalf
 Of KAM.covad
 Sent: 23 April 2009 18:53
 To: ProFox Email List
 Subject: VFP9 SP1 - need to create a statement with the report writer
 -multiple trx for a single client on one page.

 I need to create a statement using the report writer. I have created a
 lot
 of documents but none with multiple transactions on a page for each
 client.
 is there an example of an invoice/statement/report in the VFP samples
 that
 anyone would recommend?

 Also, we have several clients who want custom reports. Our program 
 gives
 the
 client full access to all tables, but unfortunately it requires the
 ability
 to program in vfp. Is anyone interested in doing some projects like
 this?
 It
 would probably be a quick low cost project but could lead into other
 things.

 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0072ca8ad8b141eb9f8f86831caca...@compaq
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added

Re: Invitation to view Ed's Picasa Web Album - Computer Books

2009-06-06 Thread Ajoy Khaund

I can see the pictures.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Gojko Bozic gojko.bo...@ius.hr
Sent: Sunday, June 07, 2009 12:32 AM
To: profoxt...@leafe.com
Subject: Re: Invitation to view Ed's Picasa Web Album - Computer Books

 Instead of pictures I see only empty frames ?!
 Gojko,


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/808c834599c9414c9b34a3a2b69c7...@compaq
** 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: Google pages

2009-05-26 Thread Ajoy Khaund

I use my hotmail account. They are giving 25 GB where you can store what you 
want. I put up the exe's in the public folder and my clients then easily 
download them.

If u r travelling you can also upload your projects to private folders and 
incase your thumb drive fails you have what you need.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Sytze de Boer sy...@kiss.co.nz
Sent: Tuesday, May 26, 2009 1:36 AM
To: profoxt...@leafe.com
Subject: Google pages

 Does anyone here on the list use google pages ?

 If yes, do you what's going to happen of you use it so people can download
 updates in exe format.
 It seems to me the new google pages equivalent won't allow you store exe
 files


 -- 
 Regards
 Sytze de Boer
 Kiss Systems
 Hamilton, NZ
 Ph: 64-7-8391670, Mob:021 937611,
 www.kiss.co.nz


 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4e1b58b8c705428d91f668f662a33...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

I just put a debug+suspend in load report there but it got called.

I wonder why ?


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Frank Cazabon frank.caza...@gmail.com
Sent: Tuesday, May 12, 2009 5:56 PM
To: profoxt...@leafe.com
Subject: Re: Microsoft release hotfix for report data group bug!

 Ajoy Khaund wrote:
 Hi

 All my apps have _screen = OFF, statusbar OFF. My main form is top level
 one. Report behaviour is set to 90. When I run the report I get 'set talk 
 on
 ' stuff like

 .T.
 GFXNORENDER
 LISTENER.VCX
 LISTENER.VCX
 LISTENER.VCX
 End of Locate Scope
 .F.
 .T.
 .T.
 .T.

 Hi Ajoy,

 check out this message (and the entire thread if you want) for a fix
 that worked for me:
 http://www.foxite.com/archives/reportbehavior-90-screen-writes-219140.htm


 -- 

 Frank.

 Frank Cazabon
 Samaan Systems Ltd. - Developing Solutions
 www.SamaanSystems.com/


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/524cb121e2ff49938a9f40d36b1c4...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

The screen writes are not to the Main Top Level form but the form on top of 
the Mainform which has a button to run the report.

BTW I am using Report form command and not the new stuff.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Tracy Pearson tr...@powerchurch.com
Sent: Tuesday, May 12, 2009 6:55 PM
To: profoxt...@leafe.com
Subject: RE: Microsoft release hotfix for report data group bug!

 I will suggest setting the TopLevelForm.AllowOutput = .F.

 Tracy


 -Original Message-
 From: Ajoy Khaund
 Sent: Monday, May 11, 2009 9:23 PM

 Hi

 All my apps have _screen = OFF, statusbar OFF. My main form is top level
 one. Report behaviour is set to 90. When I run the report I get 'set talk 
 on
 ' stuff like

 .T.
 GFXNORENDER
 LISTENER.VCX
 LISTENER.VCX
 LISTENER.VCX
 End of Locate Scope
 .F.
 .T.
 .T.
 .T.

 However if I set the statusbar ON I am not getting this characters. Since 
 I
 do not use _screen I do not have a problem if status bar is ON.

 Report behaviour 80 does not throw this output.

 Regards

 Ajoy Khaund


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/549e6d07d0cf438a8a27c845493d1...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

Sorry.

I changed the line in the FFC class as per Cathy's blog. Then I read what 
Rick wrote but it was still there even after putting 'Set Talk Off' in Views 
under Options and Tools.

So I put a debug+suspend command in the load report method of the FFC class. 
When I ran the report in Set Report behavious 90 the screen writes were 
still there.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Frank Cazabon frank.caza...@gmail.com
Sent: Tuesday, May 12, 2009 6:56 PM
To: profoxt...@leafe.com
Subject: Re: Microsoft release hotfix for report data group bug!

 Ajoy Khaund wrote:
 I just put a debug+suspend in load report there but it got called.

 I wonder why ?



 I don't understand your statement and question.

 -- 

 Frank.

 Frank Cazabon
 Samaan Systems Ltd. - Developing Solutions
 www.SamaanSystems.com/


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/add42c4b806541d1a693616aed80c...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

Wow I did not know the debugger could do that. Anyway Set Talk goes ON in 
SetFrxDataSession Method


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Grigore Dolghin gdolg...@gmail.com
Sent: Tuesday, May 12, 2009 7:05 PM
To: profoxt...@leafe.com
Subject: Re: Microsoft release hotfix for report data group bug!

 Open debugger, go to watch window, enter Set(Talk), hit Enter, it
 will go in the list below that textbox, double click in the left of
 the expression and a red dot will show up. Now run the report without
 closing the debugger. Whenever the setting for Set Talk will change,
 your program will stop and the Trace window will show the like that
 made the change. Now go there, fix it, recompile the app and you're
 set.

 On Tue, May 12, 2009 at 4:31 PM, Ajoy Khaund akha...@gmail.com wrote:
 Sorry.

 I changed the line in the FFC class as per Cathy's blog. Then I read what
 Rick wrote but it was still there even after putting 'Set Talk Off' in 
 Views
 under Options and Tools.

 So I put a debug+suspend command in the load report method of the FFC 
 class.
 When I ran the report in Set Report behavious 90 the screen writes were
 still there.


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy 
 if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Frank Cazabon frank.caza...@gmail.com
 Sent: Tuesday, May 12, 2009 6:56 PM
 To: profoxt...@leafe.com
 Subject: Re: Microsoft release hotfix for report data group bug!

 Ajoy Khaund wrote:
 I just put a debug+suspend in load report there but it got called.

 I wonder why ?



 I don't understand your statement and question.

 --

 Frank.

 Frank Cazabon
 Samaan Systems Ltd. - Developing Solutions
 www.SamaanSystems.com/


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/ab9d9e99e7374180b7e78d2550893...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

That works. Thankz.

Set Status Bar On also works.

Now I must use the workaround which I will remember.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Tracy Pearson tr...@powerchurch.com
Sent: Tuesday, May 12, 2009 7:35 PM
To: profoxt...@leafe.com
Subject: RE: Microsoft release hotfix for report data group bug!

 You could make AllowOutput = .F. in your base form class you are using.

 Tracy

 -Original Message-
 From: Ajoy Khaund
 Sent: Tuesday, May 12, 2009 9:34 AM

 The screen writes are not to the Main Top Level form but the form on top 
 of
 the Mainform which has a button to run the report.

 BTW I am using Report form command and not the new stuff.


 Regards

 Ajoy Khaund

 --
 From: Tracy Pearson
 Sent: Tuesday, May 12, 2009 6:55 PM

 I will suggest setting the TopLevelForm.AllowOutput = .F.

 Tracy



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/644300bbf94040ebb5eebac2d4697...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

In foxite you said you recompiled reportoutput.app. How do you do that ?


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Frank Cazabon frank.caza...@gmail.com
Sent: Tuesday, May 12, 2009 5:56 PM
To: profoxt...@leafe.com
Subject: Re: Microsoft release hotfix for report data group bug!

 Ajoy Khaund wrote:
 Hi

 All my apps have _screen = OFF, statusbar OFF. My main form is top level
 one. Report behaviour is set to 90. When I run the report I get 'set talk 
 on
 ' stuff like

 .T.
 GFXNORENDER
 LISTENER.VCX
 LISTENER.VCX
 LISTENER.VCX
 End of Locate Scope
 .F.
 .T.
 .T.
 .T.

 Hi Ajoy,

 check out this message (and the entire thread if you want) for a fix
 that worked for me:
 http://www.foxite.com/archives/reportbehavior-90-screen-writes-219140.htm


 -- 

 Frank.

 Frank Cazabon
 Samaan Systems Ltd. - Developing Solutions
 www.SamaanSystems.com/


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2a500cb1c53a4115a74c72885c363...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-12 Thread Ajoy Khaund

Okay Plz do that. Thankz.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Frank Cazabon frank.caza...@gmail.com
Sent: Wednesday, May 13, 2009 1:16 AM
To: profoxt...@leafe.com
Subject: Re: Microsoft release hotfix for report data group bug!

 Ajoy Khaund wrote:
 In foxite you said you recompiled reportoutput.app. How do you do that ?


 Get the xsource (which is the source code for all the VFP add ons) from
 the vfoxpro site.  Then open the reportoutputapp project, make the
 change as suggested, then build the application.  If you want, I could
 send you the recompiled application.

 -- 

 Frank.

 Frank Cazabon
 Samaan Systems Ltd. - Developing Solutions
 www.SamaanSystems.com/


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/21d6a6e957994bc6a8b37e70ec118...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-11 Thread Ajoy Khaund

Hi

All my apps have _screen = OFF, statusbar OFF. My main form is top level 
one. Report behaviour is set to 90. When I run the report I get 'set talk on 
' stuff like

.T.
GFXNORENDER
LISTENER.VCX
LISTENER.VCX
LISTENER.VCX
End of Locate Scope
.F.
.T.
.T.
.T.

However if I set the statusbar ON I am not getting this characters. Since I 
do not use _screen I do not have a problem if status bar is ON.

Report behaviour 80 does not throw this output.

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Cathy Pountney pro...@frontier2000.com
Sent: Monday, May 11, 2009 8:28 PM
To: profoxt...@leafe.com
Subject: RE: Microsoft release hotfix for report data group bug!

 The change I described on my blog for the TALK issue does work. There
 shouldn't be anything else you need to do. Please describe in more detail
 what problem you are having.

 Cathy


 -Original Message-
 From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
 On
 Behalf Of Ajoy Khaund
 Sent: Saturday, May 09, 2009 10:21 PM
 To: profoxt...@leafe.com
 Subject: Re: Microsoft release hotfix for report data group bug!

 Hi Cathy,

 I have just done a clean install of Vfp9 and then updated sp2 and then
 added
 three hot fixes. The fix given by you in your blog for 'Set Talk On' 
 while
 running a report

 Modify the fxListener class of the _ReportListener class library and
 change
 the code in the LoadReport method. Simply move
 This.setFRXDataSessionEnvironment() so it comes before
 This.createHelperObjects() and the problem is solved.

 has not worked for me. is there anything else other then this.

 Any help will be gr8 or I will have to revert to Sp1.



 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy 
 if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Cathy Pountney ca...@frontier2000.com
 Sent: Friday, April 03, 2009 2:25 AM
 To: profoxt...@leafe.com
 Subject: Microsoft release hotfix for report data group bug!

  Read about it in my blog:
  http://cathypountney.blogspot.com/2009_04_01_archive.html
 
 
 
  Cathy Pountney
 
 
 
 
 
  --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/c086d96de2864a95bb02dcf34ece8...@compaq
** 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: Microsoft release hotfix for report data group bug!

2009-05-09 Thread Ajoy Khaund

Hi Cathy,

I have just done a clean install of Vfp9 and then updated sp2 and then added 
three hot fixes. The fix given by you in your blog for 'Set Talk On' while 
running a report

Modify the fxListener class of the _ReportListener class library and change 
the code in the LoadReport method. Simply move 
This.setFRXDataSessionEnvironment() so it comes before 
This.createHelperObjects() and the problem is solved.

has not worked for me. is there anything else other then this.

Any help will be gr8 or I will have to revert to Sp1.



Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Cathy Pountney ca...@frontier2000.com
Sent: Friday, April 03, 2009 2:25 AM
To: profoxt...@leafe.com
Subject: Microsoft release hotfix for report data group bug!

 Read about it in my blog:
 http://cathypountney.blogspot.com/2009_04_01_archive.html



 Cathy Pountney





 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/289d500b60e04fe2931ff1991c35b...@compaq
** 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.

Fw: VFP9 SP1 - need to create a statement with the reportwriter-multiple trx for a single client on one page. Att: Dave Crozier

2009-05-06 Thread Ajoy Khaund

Dave,

Did you finally send this ? If yes can I have a copy. You might have 
overlooked. I wanted to go thru what you had done.

Thankz


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Ajoy Khaund akha...@gmail.com
Sent: Friday, April 24, 2009 7:08 PM
To: profox@leafe.com
Subject: Re: VFP9 SP1 - need to create a statement with the 
reportwriter-multiple trx for a single client on one page.

 Dave I would also be interested. Thankz


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Dave Crozier da...@flexipol.co.uk
 Sent: Friday, April 24, 2009 5:05 PM
 To: profoxt...@leafe.com
 Subject: RE: VFP9 SP1 - need to create a statement with the 
 reportwriter-multiple trx for a single client on one page.

 Andrew,
 Will do.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf
 Of Andrew Stirling
 Sent: 24 April 2009 12:18
 To: profox@leafe.com
 Subject: Re: VFP9 SP1 - need to create a statement with the report
 writer-multiple trx for a single client on one page.

 Dave

 Could you post the details, or perhaps put on Ed's download page.
 Thanks

 Andrew Stirling
 01250 874580
 http://www.calcpay.co.uk
 HMRC Accredited UK payroll program


 Dave Crozier wrote:
 Kam,
 I'll send you an example from our sales ledger over the weekend that
 allows
 the user to modify the reports within the system.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf
 Of KAM.covad
 Sent: 23 April 2009 18:53
 To: ProFox Email List
 Subject: VFP9 SP1 - need to create a statement with the report writer
 -multiple trx for a single client on one page.

 I need to create a statement using the report writer. I have created a 
 lot
 of documents but none with multiple transactions on a page for each
 client.
 is there an example of an invoice/statement/report in the VFP samples 
 that
 anyone would recommend?

 Also, we have several clients who want custom reports. Our program gives
 the
 client full access to all tables, but unfortunately it requires the
 ability
 to program in vfp. Is anyone interested in doing some projects like 
 this?
 It
 would probably be a quick low cost project but could lead into other
 things.

 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/73a21022419149ebb94a35dde1755...@compaq
** 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: VFP9 SP1 - need to create a statement with the reportwriter-multiple trx for a single client on one page.

2009-04-24 Thread Ajoy Khaund

Dave I would also be interested. Thankz


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Dave Crozier da...@flexipol.co.uk
Sent: Friday, April 24, 2009 5:05 PM
To: profoxt...@leafe.com
Subject: RE: VFP9 SP1 - need to create a statement with the 
reportwriter-multiple trx for a single client on one page.

 Andrew,
 Will do.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
 Of Andrew Stirling
 Sent: 24 April 2009 12:18
 To: profox@leafe.com
 Subject: Re: VFP9 SP1 - need to create a statement with the report
 writer-multiple trx for a single client on one page.

 Dave

 Could you post the details, or perhaps put on Ed's download page.
 Thanks

 Andrew Stirling
 01250 874580
 http://www.calcpay.co.uk
 HMRC Accredited UK payroll program


 Dave Crozier wrote:
 Kam,
 I'll send you an example from our sales ledger over the weekend that
 allows
 the user to modify the reports within the system.

 Dave Crozier

 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf
 Of KAM.covad
 Sent: 23 April 2009 18:53
 To: ProFox Email List
 Subject: VFP9 SP1 - need to create a statement with the report writer
 -multiple trx for a single client on one page.

 I need to create a statement using the report writer. I have created a 
 lot
 of documents but none with multiple transactions on a page for each
 client.
 is there an example of an invoice/statement/report in the VFP samples 
 that
 anyone would recommend?

 Also, we have several clients who want custom reports. Our program gives
 the
 client full access to all tables, but unfortunately it requires the
 ability
 to program in vfp. Is anyone interested in doing some projects like this?
 It
 would probably be a quick low cost project but could lead into other
 things.

 --- 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://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/18fb2392cc404bc8929e2c7ff9fb1...@compaq
** 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: Accounts package - open-source?

2009-04-08 Thread Ajoy Khaund

The reports in this package have a lot of export options. Can anyone throw
some light on how they are doing that. Is it some thid party tool or pure
Vfp6.

TIA

Ajoy Khaund

On Tue, Apr 7, 2009 at 11:52 PM, MB Software Solutions General Account 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 Jean Laeremans wrote:
  Just wondering why they use IDX indexes...


 Legacy code from years ago I bet...




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3590904081920p34f0eb7eh7218216b2209a...@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.

Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

Hi All,

I am using a view in a form for a order entry screen. The form works fine but 
sometimes a 'Save' of the view fails. Then the view is rebuilt the 'Save' works 
again. I cannot reproduce it. Should I close and open the view when user clicks 
on the 'Add' button.

TIA


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2a773ab7285c427d862dda5766d78...@compaq
** 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: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

Thankz. Since it does not happen always and I cant reproduce it how do I 
trap the error and save it to somewhere.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rick Schummer pro...@whitelightcomputing.com
Sent: Thursday, April 02, 2009 9:00 PM
To: profoxt...@leafe.com
Subject: RE: Save fails sometimes Vfp9 Sp1

 The form works fine but sometimes a 'Save' of the view fails.

 Have you checked the result of the TABLEUPDATE() to see if it fails, and
 then check AERROR() to see what the internal reason is?

 Sounds like you have a data conflict.


 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/10069f04e2124ae6abeabb3a448c4...@compaq
** 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: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

SELECT Lineitems.seq, Lineitems.prodname, Lineitems.orderqty, 
Lineitems.punit, Lineitems.unitprice, Lineitems.taxrate, Lineitems.ordertax, 
Lineitems.orderprice, Lineitems.linecost, Lineitems.remarks, 
Lineitems.recdqty, Lineitems.orderdisc, Lineitems.others, 
Lineitems.productid, Lineitems.orderid, Lineitems.lineitemid, 
Lineitems.indentid FROM tstore!lineitems WHERE  Lineitems.orderid = ( 
?LP_ORDERID ) ORDER BY Lineitems.seq


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: MB Software Solutions General Account 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, April 02, 2009 10:39 PM
To: profoxt...@leafe.com
Subject: Re: Save fails sometimes Vfp9 Sp1

 Rick Schummer wrote:
 The form works fine but sometimes a 'Save' of the view fails.

 Have you checked the result of the TABLEUPDATE() to see if it fails, and
 then check AERROR() to see what the internal reason is?

 Sounds like you have a data conflict.


 Agreedwhat's your WhereType for the view, Bobby?




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/37ca74d7b60d4cf7829872368084f...@compaq
** 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: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

Sorry its

key  modified fields


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: MB Software Solutions General Account 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, April 02, 2009 10:39 PM
To: profoxt...@leafe.com
Subject: Re: Save fails sometimes Vfp9 Sp1

 Rick Schummer wrote:
 The form works fine but sometimes a 'Save' of the view fails.

 Have you checked the result of the TABLEUPDATE() to see if it fails, and
 then check AERROR() to see what the internal reason is?

 Sounds like you have a data conflict.


 Agreedwhat's your WhereType for the view, Bobby?




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5941e265215a43f2b7d3ee8bc185d...@compaq
** 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: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

App is single user. Fields of Parent 'Orders' table is on the form. The 
child records are displayed in a view. On 'Add' or 'Edit' to child records a 
form appears where productid, qty, remarks etc are written  saved. Now 
sometimes after 'Save' when the form closes the record does not appear in 
the grid. Since u said data conflict. I did see a small error message once 
when the user was using. When can such errors occur. Any ideas will hep as 
this is a very simple form.

Michael asked about whertype ? Any link ??? What should a wheretype 
generally be ???


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rick Schummer pro...@whitelightcomputing.com
Sent: Thursday, April 02, 2009 10:44 PM
To: profoxt...@leafe.com
Subject: RE: Save fails sometimes Vfp9 Sp1

Since it does not happen always and I cant reproduce it how do I trap the
 error and save it to somewhere.

 If you cannot reproduce the problem, it likely is a data conflict as I
 mentioned, but it could be a different bug.

 I already told you how to determine the problem (check the tableupdate and
 use AERROR() to find the reason. Recording the error is up to you. Dump 
 the
 array into a table or something simple like a text file.

 IF TABLEUPDATE()  check the parameters you need to pass for your cursor
   * All is well
 ELSE
   * Not so well
   AERROR(laDataError)
   LIST MEMO LIKE laDataError TO FILE DataNotSaved.txt
 ENDIF

 Bullet proof my code sample as needed for your customer environment.

 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/886208cd64104f4ba5ce261a8da56...@compaq
** 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: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund

Thankz for taking so much of your time. I really appreciate it. Well it 
could be two different forms were opened which have similar views. Let me 
look into it. I remember the user was going and checking a few things when 
the Orders form was open.

The send form which opens to add child records open in the default data 
session.

I have changed the wheretype to 1. Frankly speaking I have never understood 
that. It worked in setting 3 and so I never changed it. Setting 1 makes 
sense.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rick Schummer pro...@whitelightcomputing.com
Sent: Friday, April 03, 2009 12:24 AM
To: profoxt...@leafe.com
Subject: RE: Save fails sometimes Vfp9 Sp1

 Your app might be used by a single user, but the app can be effectively
 multiuser with private datasessions and two instances of the same form or
 different forms with the same data.

 The Key and Modified will return a data conflict if the same record is
 edited in two forms. What happens is each form the view is queried. One
 query is has the changes committed. The second form tries to commit the
 changes. If the key or any of the fields being modified in the second
 instance are different than the table the view cannot be committed. If 
 form
 one changed the customer name field, and the second one changed the 
 address
 field the second view will get committed.

 What you are seeing with the view being requeried is the buffer get a 
 fresh
 set of the data from the table. This lessens the chance of the conflicts. 
 If
 you changed the view to key only you implement a last one wins scenario.
 Whoever saves the data last always has their information committed to the
 table. This works for certain business situations.

 This second form, is it using the default data session (which is the same 
 as
 the calling form) or is it a private data session? If it is private and it
 opens the data and commits changes, it would effectively cause the problem
 you are seeing provided the error you are getting is a data conflict - and
 have not told us the results of this. We could be chasing our tail here.

 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com




 -Original Message-
 From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] 
 On
 Behalf Of Ajoy Khaund
 Sent: Thursday, April 02, 2009 01:33 PM
 To: profoxt...@leafe.com
 Subject: Re: Save fails sometimes Vfp9 Sp1

 App is single user. Fields of Parent 'Orders' table is on the form. The
 child records are displayed in a view. On 'Add' or 'Edit' to child records 
 a

 form appears where productid, qty, remarks etc are written  saved. Now
 sometimes after 'Save' when the form closes the record does not appear in
 the grid. Since u said data conflict. I did see a small error message once
 when the user was using. When can such errors occur. Any ideas will hep as
 this is a very simple form.

 Michael asked about whertype ? Any link ??? What should a wheretype
 generally be ???


 Regards

 Ajoy Khaund
 Neamati Road
 Near Bhogdoi Bridge
 Jorhat 785001-21
 Assam, India

 Tel: 91-376-2351288
 Cell: 91-94350-92287
 Mail: akha...@hotmail.com
 Mail: akha...@gmail.com

 Walking on water and developing software from a specification are easy if
 both are frozen.
 - Edward  V. Berard, Life-Cycle Approaches

 --
 From: Rick Schummer pro...@whitelightcomputing.com
 Sent: Thursday, April 02, 2009 10:44 PM
 To: profoxt...@leafe.com
 Subject: RE: Save fails sometimes Vfp9 Sp1

Since it does not happen always and I cant reproduce it how do I trap 
the
 error and save it to somewhere.

 If you cannot reproduce the problem, it likely is a data conflict as I
 mentioned, but it could be a different bug.

 I already told you how to determine the problem (check the tableupdate 
 and
 use AERROR() to find the reason. Recording the error is up to you. Dump
 the
 array into a table or something simple like a text file.

 IF TABLEUPDATE()  check the parameters you need to pass for your cursor
   * All is well
 ELSE
   * Not so well
   AERROR(laDataError)
   LIST MEMO LIKE laDataError TO FILE DataNotSaved.txt
 ENDIF

 Bullet proof my code sample as needed for your customer environment.

 Rick
 White Light Computing, Inc.

 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive

vfp9 Sp1 to Sp2

2009-04-02 Thread Ajoy Khaund

Hi All,

Currently I have Sp1 and want to give Sp2 a try. I had read before I must do a 
clean install of Vfp9 then apply sp2 and then apply hotfix of 2nd April 2009.

If I am wrong can anyone correct me.


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/8718206f99464caa877111549f1ec...@compaq
** 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, EDI XML - Oh My...

2009-02-17 Thread Ajoy Khaund

Rafael,

I also have an app where data is exported at the branch office and imported 
at the headoffice. I use dbf's. Why are you using a XML ? Is there any 
advantage ?


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Rafael Copquin rcopq...@ciudad.com.ar
Sent: Tuesday, February 17, 2009 6:09 PM
To: profoxt...@leafe.com
Subject: Re: VFP, EDI  XML - Oh My...

 Hi Kurt

 Sorry for not replying earlier. If I get you correctly, you need to import
 an XML file into VFP.
 To be quite honest with you, I never used a schema file. But I do send 
 data
 over the web in the manner I showed you in my earlier post.
 The process is this:

 The store creates an XMLAdapter object and loads different cursors into it
 with the daily sales, cash receipts, stock positions, etc.
 Then it sends the resulting xml file through the internet to the head
 office.
 At the head office they convert this xml file into the contained cursors,
 using the XMLAdapter class, as I showed you how.
 Then, the program uses those cursors to integrate the data into the main
 head office files.

 Now, there are many ways you can send the XML file to the head office:

 ftp
 email
 webservice

 If all of the above fails, you can simply load the xml file in a pendrive
 and have a biker take the device to head office every day. It seems like a
 joke, but I actually have one client who does just that, simply because 
 the
 store is in the city, the head office is in the outskirts of the city and
 they have a lousy internet connection (it is the IP provider's fault,with
 frequent disconnections). So the simple solution, and super effective, is 
 to
 have this guy jump onto his motorbike and speedily deliver the pendrive to
 HQ. (one of the delights of living in this country, there is always a
 solution available when technology plays against you - (;)  )

 Regards

 Rafael Copquin


 - Original Message - 
 From: Kurt Wendt kurtwe...@waitex.com
 To: profoxt...@leafe.com
 Sent: Friday, February 13, 2009 7:00 PM
 Subject: RE: VFP, EDI  XML - Oh My...


 Hey there Rafael,

 Thanks for the input. In between the time I wrote the original message
 for help - and now - I actually got something figured out. I was able to
 pull in 2 database tables into an XML file, and even have those 2 files
 linked via a Set Relation. Then I had found the .ToCursor command and
 was able to output the data into cursors.

 Now, during my experimentations - I found that if I double-clicked on a
 Schema file (XSD) - MS Visual Studio on my PC here at work automatically
 opened up the Schema file for viewing. So, since this MS VS tool allowed
 me to open up a Schema file - I figured I would see what I else I could
 do.

 I had this sample XML file - an EDI Order file - for which I eventually
 need to import into the VFP database system here. Problem is - I did not
 have a Schema file for this XML file. And, since I figured I needed the
 Schema in order for me to import the file into VFP - I opened up the XML
 file in MS VS - and I found I could Export from MS VS a Schema file.

 At that point I tried to use this newly created Schema file, along with
 the sample XML file - but, I ended up getting a strange error when the
 .LoadXML command attempted to execute. It claimed that:
 XML Schema is Too complex!

 When I opened that Schema file up in MS VS - the tree diagram shows it
 as 4 levels deep. Can that be the case - that VFP and the XMLAdapter is
 unable to handle something like 4 levels deep???

 TIA,
 -K-

 -Original Message-
 From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
 On Behalf Of Rafael Copquin
 Sent: Friday, February 13, 2009 4:14 PM
 To: profoxt...@leafe.com
 Subject: Re: VFP, EDI  XML - Oh My...

 Hi there Kurt

 try this:

 ** open two tables, put them inside an xml and send the xml away

 Clear All
 Close All

 Public oXML,cXML

 Use clientes In 0 Alias customers
 Use proveed In 0 Alias suppliers

 oXML=CreateObject('XMLAdapter')
 oXML.addtableschema('customers')
 oXML.addtableschema('suppliers')

 oXML.toXML('cXML')
 Release oXML
 Use in customers
 Use in suppliers


 ** you now have a property in memory called cXML

 ** you can send this property to a receiving computer via Internet

 ** at the other side do this
 Public oXML
 oXML=CreateObject('XMLAdapter')
 oXML.loadxml(cXML)
 oXML.tables(1).tocursor(.f.,'curCustomers')
 oXML.tables(2).tocursor(.f.,'curSuppliers')

 Select curCustomers
 Browse
 Select curSuppliers
 Browse
 Clear All
 Close All






 - Original Message - 
 From: Kurt Wendt kurtwe...@waitex.com
 To: profoxt...@leafe.com
 Sent: Friday, February 13, 2009 12:10 PM
 Subject: VFP, EDI  XML

Combo in Grid Vfp9

2009-02-04 Thread Ajoy Khaund

Hi,

I have a grid with three columns to enter terms for an invoice. The first 
column is description of the term, the second column is to enter percentage and 
the third column is to enter amount.
If the Term is connected to a Tax code then in column2 a drop-down combo will 
allow a taxcode selection.

To show the combo or textbox I have set the dynamic control property and its 
working.

The controlsource for the combo is another column.How do I make the combo show 
the right description. Now the percentage is getting overwritten by the 
listindex of the combo.

Anythoughts


Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/ae9f166580854911ba0f813bf8426...@compaq
** 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: Multiple reports, side-by-side, same page

2009-02-03 Thread Ajoy Khaund

Have four fields in your cursor Say field1,field2,field3,field4
Scan customer
Append blank and fill up field1 and field2
endscan

scan vendor
fill up field3 and field4 by replace and append if vendor list is longer 
then customer list
endscan

then inventory list and order number list.

for header you can fill field1 with Customer List and have a field for 
making it bold. say boldfield1 L. set it to .T. when filling a header.

Hope this helps.

Regards

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: John J. Mihaljevic john.mihalje...@gmail.com
Sent: Wednesday, February 04, 2009 3:11 AM
To: profoxt...@leafe.com
Subject: Multiple reports, side-by-side, same page

 Hi all,

 I have a request to produce several very short reports, but they can't be 
 on
 separate pages. In fact, they need to be side-by-side on as few pages as
 possible using different sets of data.

 For example, imagine the left side of the page has a report called
 Customers and lists CustomerNumber, CustomerName. And on the right side,
 there's another report called Vendors that lists VendorNumber, 
 VendorName.

 Below those two reports, are two more. On the left side of the page,
 Inventory lists PartNumber, PartName. And on the right side, there's a
 report called Orders which lists OrderNumber and DueDate.

 Etc., etc., etc.

 Using the VFP Report Designer, is this possible?

 Thanks very much,

 John


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/a793b062203148f5b1b009dd9149a...@compaq
** 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: Evaluating XFRX

2009-01-27 Thread Ajoy Khaund

Thankz in the example the source code is there to generate the preview. Its 
working. Let me check out.


Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--
From: Ajit Abraham fox...@ua-group.com
Sent: Tuesday, January 27, 2009 10:24 AM
To: profoxt...@leafe.com
Subject: Re: Evaluating XFRX

 Ajoy,

 Instead of the PDF, check if you can see the report in the xfrx preview
 container.

 Sincerely,

 _Ajit Abraham

 Ajoy Khaund wrote:


 lnRetval = loxfrx.SetParams(d:\output.pdf,,PDF)



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/7afb6237533c46e682e9d8a5d9805...@compaq
** 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.

Evaluating XFRX

2009-01-26 Thread Ajoy Khaund

Hi,

I have downloaded XFRX for Vfp9 to folder called XFRX into my D drive.

I have a personal accounts package so I am trying XFRX there.I have set the 
path to D:\XFRX and D:\XFRX\UTREPLISTENER where I have unzipped the utility 
report listener.

Now in a form after generatin the report cursor I have added the following 
lines:

*Thisform.ReportPreview(gl)

SET CLASSLIB TO (HOME()+ffc\_reportlistener)

Local loSession, lnRetval

loSession = Evaluate(xfrx('XFRX#INIT'))

loxfrx = XFRX(XFRX#LISTENER)

lnRetval = loxfrx.SetParams(d:\output.pdf,,PDF)

If lnRetval = 0

Report Form GL Object loxfrx Nopageeject

* Report Form report2 Object loxfrx

Else

? lnRetval

Endif

I see a wait window in the side which shows pages 1 to 5 been rendered but the 
pdf generated cannot be opened. Pdf generation is not so important for me. How 
do I get the previewer ? Or is it not available in the evaluation version. I 
want to try excel and text reports mainly.

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India


Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/col117-ds2245c4f18545070d3903cab3...@phx.gbl
** 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.

Vfp9 Grid Currentcontrol

2009-01-23 Thread Ajoy Khaund

Hi All,

I have a cursor (desc C(25),percentage N(6,2),amount N(10,2),taxcode C(1))

The grid which I have made has three columns.
For rows where taxcode is blank textbox has to be displayed in all columns.
OK

For rows where taxcode is not empty it must display a combobox in column 2
to pick the taxcode to be applied.

TIA
-- 

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3590901230120x63cdf853j3cc6e9c268a2a...@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.

Fwd: Vfp9 Grid Currentcontrol

2009-01-23 Thread Ajoy Khaund

DynamicCurrentcontrol fixed it.
After I send a mail the brain starts working somehow.

-- Forwarded message --
From: Ajoy Khaund akha...@gmail.com
Date: Jan 23, 2009 2:50 PM
Subject: Vfp9 Grid Currentcontrol
To: Profox profox@leafe.com

Hi All,

I have a cursor (desc C(25),percentage N(6,2),amount N(10,2),taxcode C(1))

The grid which I have made has three columns.
For rows where taxcode is blank textbox has to be displayed in all columns.
OK

For rows where taxcode is not empty it must display a combobox in column 2
to pick the taxcode to be applied.

TIA
-- 

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

-- 

Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/2144f3590901230354i11fa9129nedead5d55c034...@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.

Vfp9 Try command

2009-01-17 Thread Ajoy Khaund

Hi All,

I am downloading data from a logger through a serial port device. The data 
string from the serial port has junk for the date field as a result of which an 
error is coming. How can I put it in a Try block. The over all code is like:

Scan

Try
ldate =  something
ldate = something date time
error over here


catch
Messagebox()
LOOP 

endtry
Endscan

Is this how it is done. I am getting my msgbox but I still get a vfp error 
message. How to avaoid that.

TIA


Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785001-21
Assam, India

Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: akha...@hotmail.com
Mail: akha...@gmail.com

Walking on water and developing software from a specification are easy if
both are frozen.
- Edward  V. Berard, Life-Cycle Approaches

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/f5d903c3e2b04e1ebb1ab68e96b9c...@compaq
** 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.

1 2 >

1 - 100 of 183 matches

Mail list logo