Hi all. I am having a problem with this sql and I do not know why. I am using mySQL. The error I am generating is:
error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(30), `sw_service_pack_major_version` integer(3), `sw_service_pack_minor_versi' at line 1 I cannot see what is wrong. I deleted every column beyond where the error says I am having a problem and it works! Is there a hard limit to how big a query can be? If not, then is there a limit to how big an ON-REV query can be?? As a side note, I take the SQL to create a table from sqLite, massage it to work in mySQL then execute it. Not sure if that gives you a vector on the issue but the more information the better I always say. Bob CREATE TABLE `slylabs_Helpdesk`.`sw_devices` ( `uniqueid` mediumint(3) unsigned zerofill NOT NULL auto_increment, `deleted` boolean DEFAULT FALSE, `updated` boolean DEFAULT FALSE, `sw_id` INTEGER NOT NULL, `sw_name` varchar(50) NOT NULL, `sw_type` varchar(50), `sw_description` varchar(80), `sw_server_name` varchar(50), `sw_domain` varchar(50), `sw_uuid` varchar(50), `sw_manufacturer` varchar(50), `sw_model` varchar(50), `sw_os_serial_number` varchar(70), `sw_windows_product_id` varchar(50), `sw_serial_number` varchar(75), `sw_ip_address` varchar(15), `sw_mac_address` varchar(50), `sw_operating_system` varchar(64), `sw_version` varchar(50), `sw_windows_user` varchar(50), `sw_primary_owner_name` varchar(50), `sw_memory` integer, `sw_management_oid` varchar(75), `sw_up_time` varchar(50), `sw_last_boot_up_time` datetime(30), `sw_service_pack_major_version` integer(3), `sw_service_pack_minor_version` integer(3), `sw_number_of_licensed_users` integer(3), `sw_number_of_processors` integer(3), `sw_processor_type` varchar(50), `sw_created_on` datetime, `sw_updated_on` datetime, `sw_kernel` varchar(255), `sw_page_count` integer, `sw_install_date` datetime, `sw_device_type` varchar(255), `sw_current_user` varchar(255), `sw_bios_version` varchar(255), `sw_location` varchar(255), `sw_online_at` datetime, `sw_offline_at` datetime, `sw_asset_tag` varchar(255), `sw_manually_added` boolean DEFAULT FALSE, `sw_bios_date` date, `sw_c_purchase_price` float, `sw_c_purchase_date` date, `sw_b_name` varchar(50), `sw_b_location` varchar(255), `sw_b_device_type` varchar(255), `sw_b_asset_tag` varchar(255), `sw_b_manufacturer` varchar(50), `sw_b_model` varchar(50), `sw_b_primary_owner_name` varchar(50), `sw_b_serial_number` varchar(75), `sw_warning_alert_count` integer DEFAULT 0, `sw_error_alert_count` integer DEFAULT 0, `sw_open_ticket_count` integer DEFAULT 0, `sw_auto_tag` varchar(255), `sw_dn` varchar(255), `sw_c_passwd_update` varchar(255) DEFAULT `Yes`, `sw_c_dept_device` varchar(255) DEFAULT `Not Assigned`, `sw_user_tag` varchar(255), `sw_exclude_tag` varchar(255), `sw_last_scan_time` datetime, `sw_site_name` varchar(255), `sw_spice_version` integer, `notes` blob NOT NULL, `signature` char(2) NOT NULL, PRIMARY KEY (`uniqueid`) ) _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
