Entries RSS Comments RSS

Your Ad Here

Posts Tagged ‘Microsoft Visual Foxpro’

FoxPro Save Code

Friday, July 31st, 2009

Saving a record in a table or database is one of the basic capabilities of Microsoft Visual FoxPro. Save applies to two meaning which is the Add and Edit. Add is incrementing a newly encode data to the table while Edit is amending or altering of your previously saved data.

First, saving of a data by Add:

SELECT TableName
APPEND BLANK
REPLACE FieldOne WITH THISFORM.TEXT1.Value
REPLACE FieldTwo WITH THISFORM.TEXT2.Value
REPLACE FieldThree WITH THISFORM.COMBO1.Value
REPLACE FieldFour WITH THISFORM.COMBO2.Value
INSERT INTO TableName (FieldOne, FieldTwo, FieldThree,FieldFour);
VALUES (THISFORM.TEXT1.Value, ;
THISFORM.TEXT2.Value, ;
THISFORM.TEXT3.Value, ;
THISFORM.TEXT4.Value)
Second saving a data by Edit:
SELECT TableName
REPLACE FieldOne WITH THISFORM.TEXT1.Value
REPLACE FieldTwo WITH THISFORM.TEXT2.Value
REPLACE FieldThree WITH THISFORM.COMBO1.Value
REPLACE FieldFour WITH THISFORM.COMBO2.Value
INSERT INTO TableName (FieldOne, FieldTwo, FieldThree,FieldFour);
VALUES (THISFORM.TEXT1.Value, ;
THISFORM.TEXT2.Value, ;
THISFORM.TEXT3.Value, ;
THISFORM.TEXT4.Value)

SELECT TableName

APPEND BLANK

REPLACE FieldOne WITH THISFORM.TEXT1.VALUE

REPLACE FieldTwo WITH THISFORM.TEXT2.VALUE

REPLACE FieldThree WITH THISFORM.COMBO1.VALUE

REPLACE FieldFour WITH THISFORM.COMBO2.VALUE

Or

INSERT INTO TableName (FieldOne, FieldTwo, FieldThree,FieldFour);

VALUES (THISFORM.TEXT1.VALUE, ;

THISFORM.TEXT2.VALUE, ;

THISFORM.TEXT3.VALUE, ;

THISFORM.TEXT4.VALUE)

Second saving a data by Edit:

SELECT TableName

REPLACE FieldOne WITH THISFORM.TEXT1.VALUE

REPLACE FieldTwo WITH THISFORM.TEXT2.VALUE

REPLACE FieldThree WITH THISFORM.COMBO1.VALUE

REPLACE FieldFour WITH THISFORM.COMBO2.VALUE

Or

INSERT INTO TableName (FieldOne, FieldTwo, FieldThree,FieldFour);

VALUES (THISFORM.TEXT1.VALUE, ;

THISFORM.TEXT2.VALUE, ;

THISFORM.TEXT3.VALUE, ;

THISFORM.TEXT4.VALUE)

Tags: , , , , ,
Posted in FoxPro, Software | 9 Comments »

Top Ten Application to be Installed

Friday, July 10th, 2009

After I bought a laptop and formatted it with Windows XP (I’m comfortable with XP than Vista) and installed its driver (drivers are included when you buy a laptop or any computer hardware), I still can’t fully utilize it without my top ten must-have application/program to be installed on my workstation. So here goes my list according to what I need and of course what I want..

Irfanview 4.10

Since the company I am working deals a lot with scanned documents such as contracts, pictures, certificates, passport, etc that needed to be kept and upload, we are required to deal with the Irfanview for proper uploading on the database.

QuickTime

My multimedia preference and suitable for Iphone, Itouch or any Apple products

Macromedia

Macromedia Fireworks, Macromedia Flash and Macromedia Dreamweaver are my list of Macromedia. Although I didn’t fully utilize them, they are great alternative for Adobe Photoshop, Moviemaker or PHP or Notepad.

Chrome

I got better viewing of my WordPress in Chrome than Internet Explorer plus I like their interface.

Skype or Yahoo Messenger

Must have messenger! You can contact me on my Skype account muffie.rojas and my Yahoo Messenger account m_f_t_rojas

Chikka

Don’t have any load? You can text for free using this messenger. But aside from sending message to computer, your message will be forward on the cell phone. You have different credits on Smart, Globe, US Mobile Phones, Cingular Wireless, Sun, Guam Cell, Saipan Cell, India Mobile Phones, , Verizon Wireless, Sprint, Alltel, Excelcomindo, Nextel, Boost, UK, Spain, 1528 Smart HK, Smart Pinoy Italy.

Adobe Photoshop

Do I need to explain?! Before uploading pictures, you need to at least resize, add designs, and of course edit your picture for more effect and to erase those unwanted pixel ha ha!!

Microsoft Visual Foxpro

My first fully learned program. Very usable in making a system in different unit or department plus it is very easy to utilize. I’ll be posting more FoxPro code on my upcoming articles.

Eset Antivirus

My workstation defense against viruses, spyware, root kits, and other internet attacks. Keeping my workstation and data safe from hackers and thieves.

Microsoft Office 2007

My all-around application that is being use. We have the MS Excel, MS Outlook, MS PowerPoint, MS Publisher, MS Word and MS Project. I‘m betting on Microsoft Office 2007, not that I don’t like the Microsoft Office 2003, but 2007 got more features than the latter and I’m used to 2007.

That’s it for now.. More Top Ten to come!

Tags: , , , , , , , , , , , , , , ,
Posted in Software, Technology, Top Ten | 14 Comments »

E Voucher – My First Baby

Friday, June 19th, 2009
evoucher

E Voucher

I started programming using Microsoft Visual FoxPro last August 2008. My first project – Electronic Voucher also known as E Voucher. Although I am not familiar with programming and I really sucked in codes (I can’t even make a decent program when I was in college), I was forced to do the project because our first Solution Developer left.

I started with the basic, the Add, the Edit and the Delete, and being an optimistic I thought it was easy! But as the demand of the function increased, same with pressure I got. Remember that I don’t have any background in any kind of programming language. E-Voucher could have been easy but the facts it consist of accounting chuva chenez make it worse! Cash and Check Voucher, Report Expenses, Summary of Accounts and Summary of Expenses – please bring me back to Technical Support!

I spent so many hours working and developing my knowledge in Microsoft Visual FoxPro on that project. Cases such as late night work, Saturday duty and Holiday duty are pretty known and common to me. And I had learned a lot on that project especially the ‘work around’ technique. My boss introduce to me the meaning of work around, and I have a different meaning on that word – an improvise function that is hidden within your codes intended to replace a code that is not yet known to me.

Aside from that I had this bizarre dream at night where I was still coding. Plus my social life temporary disappeared. But let’s not make my first baby a monster! I am happy that I got that project because I am here where I suppose to be. I was forced to study and learn, and it was not so bad. I had sacrificed a lot but it’s all worth it. Now my horizon is getting wider and I it all started on my E Voucher.

Now I dedicate a part of my blog on program codes to those who might want to learn or looking for codes. Hope that this might help others not to turn to work around.

Watch out for more Microsoft Visual FoxPro codes that I used in E Voucher, Muffie Shannen signing off..

Tags: , , , , ,
Posted in Software, Technology, The Notebook, Workaholic | 8 Comments »

 

Submit to Social Websites