Question on Relating Tables

Article View: borland.public.vdbase.data.sql

Article #1270

Back to borland.public.vdbase.data.sql Previous Next

#1270

From: Brian
Date: Fri, 27 Mar 1998 00:00

21 lines
1075 bytes

I'm trying to convert Visual dbase 5.5 programming to Visual dbase 7.0

I just found out that masterfields doesn't allow an expression and so I
tried the SQL writer in Visual dbase 7.0 but didn't get anywhere with
that either.  However, would you write the following xbase code in
Visual dbase 7.0:

SELECT 1
USE INVOICE 
SELECT 2
USE SALES ORDER INVOICE
// INVOICE TAG IS BASED ON SALES->TICKETNO
SELECT 1
SET RELATION TO DTOS(DATEOT)+LOCATION+'-'+NUMBER INTO INVOICE

The problem is the expression: DTOS(DATEOT)+LOCATION+'-'+NUMBER

Hope you have an easy solution.  Thanks.

Brian

Technical Details

Message-ID: <351C5B43.2794@netgrp.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4fd2244783f53482,start
X-Google-Attributes: gidff5a1,public
From: Brian <bfred@netgrp.net>
Subject: Question on Relating Tables
Date: 1998/03/27
Message-ID: <351C5B43.2794@netgrp.net>
X-Deja-AN: 338447306
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql