BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Search
Login Register Member List
  » BaseNow Forums   » Bug Reports   » SQL Query builder problem  

Welcome Guest ( Login or Register )
Recent Topics | 

SQL Query builder problem
Rate This Topic
Topic Options
Author
Message
ivanhalen
Posted 11/16/2005 5:42 AM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/21/2005
Posts: 2

Hi,

I can't execute this SQL

SELECT
 BRANDS.*,
 CATEGORIES.*,
 PRODUCTS.*
FROM
 (PRODUCTS
 LEFT JOIN BRANDS ON BRANDS.BRA_ID = PRODUCTS.PRO_BRAND)
 INNER JOIN CATEGORIES ON CATEGORIES.CAT_ID = PRODUCTS.PRO_CATEGORY

When I try to execute query I get this alert: "Microsoft DataGrid Control: Cannot initialize data bindings"

Please, what's the problem?
Thanks

IP Logged
This member is offline.
Nenad Oric
Posted 11/21/2005 1:38 AM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 8/9/2024
Posts: 64
Unfortunately, such query is not supported in the Query Builder tool. Try to specify the exact names of the columns after the SELECT keyword.
IP Logged
This member is offline.
ivanhalen
Posted 11/21/2005 1:28 PM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/21/2005
Posts: 2

..nice..

IP Logged
This member is offline.
Showing page 1 of 1 - 3 messages found
« Next Oldest

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.