Entries RSS Comments RSS

Your Ad Here

Posts Tagged ‘Program’

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 »

Microsoft Visual FoxPro

Friday, July 24th, 2009

foxpro

For those of you who are unfamiliar with Microsoft Visual FoxPro, it is a data-centric object-oriented and procedural programming language produced by Microsoft. You can create database, table, local view, remote view, connection, form, report, class, code and menu.

It gives you the opportunity to develop a program or application on a standalone computer or even on a local area connection database. One of its capabilities is to support SQL query and data manipulation. Unlike most database management systems, Visual FoxPro is a full-featured, dynamic programming language that does not require the use of an additional general-purpose programming environment.

I wanted to clear up some confusion created over the past couple of years surrounding the FoxPro; specifically how other tells that it is an obsolete programming language. As other Programmer stated, it meant to streamline the work experience and provide easy manageability to Programmer with the utilization of its feature. The strategy with Microsoft Visual FoxPro short for VFP is to facilitate or assist you on developmental task content, not to be a conventional service.

Last few months, Marlow Navigation IT Department makes use of Microsoft Visual FoxPro as means of Solutions Developers main tool to develop programs in different department and unit. In response, a total of six programs were made and still ongoing up to this date and more than a fifty employees are using it.

I am still in very early stages of developing with Microsoft Visual FoxPro system, but I wanted to share some knowledge and information I learned so I will be posting codes on my next post.

As always, keep the feedback coming as I continue to think about ways to share this very useful tool.

Tags: , , , ,
Posted in FoxPro, Software, Technology | 10 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 »

 

Submit to Social Websites