Database

jojoba2011 wrote:

delete table

jojoba2011 wrote:

without changing the data in customer DB

Kevin Marois wrote:

All variables in xBase are False by default.

Kevin Marois wrote:

...so it will get its type when assigned to.

char(1) myvar[11]
myvar[1] = Chr(32)
myvar[2] = Chr(45)
myvar[3] = "Hello"
myvar[3] = DATETIME()
myvar[10] = Chr(124)

VFP is a weakly typed language, that is, the compiler allows operations such as assignment and comparison among variables of different types. For example, VFP allows the value of a variable to be cast to another type. The ability to use variables of different types in the same expression promotes flexibility as well as efficiency.

Note: Strong typing in Visual FoxPro 7/8/9 SP2 is not enforced at compile or run time, but is used primarily at design time.

Kevin Marois wrote:

Do you know what language this code was written in?

Kevin Marois wrote:

If it compiles in one, it should in another with minimal work.

Customer = "Smith"
Customer = CreateObject("Excel.Application") 
Customer = .T. 

LOCAL CustomerName AS String

LOCAL CustomerName AS String
CustomerName = 10+5

sindhuan wrote:

Is this the right way to do??

dc.users.InsertOnSubmit("us");

dc.users.InsertOnSubmit(us);

using (MyDataContext dc = new MyDataContext())
{
    var userName = (from u in dc.tblUsers
                    where u.Id = someId
                    select u.UserName).FirstOrDefault();


    user us = new user
    {
        Date = DateTime.Now,
        name = userName
    };

    try
    {
        dc.users.InsertOnSubmit(us);
    }
    catch(Exception e)
    {
        // Handle exception here
    }
}