Form submit db_query issue

Finally got this working in a module. A couple of problems I ran into in case anybody is as new to this as me:
rower_results_form doesn't work because in the .info file the name is = Rower Results
Rower_Results_form solves that problem

db_insert('dr_rower_results') does not work
db_insert( ) automatically adds 'dr_' to the start of the node name, so simply writing:
db_insert('rower_results') when the node is named 'dr_rower_results' works

Also, while a MySQL query may allow an "INSERT INTO" without including values for all fields, the Drupal db_insert( ) requires that ALL fields are specified (unless they have a default value)

Anyways, thanks Jaypan for the help, and I hope this helps somebody who's as lost as I was a week ago!

Here is my working code for anyone interested:

<?php
/**
 * @file
 * This module allows users to input information for rower race results.
 */
 
 function Rower_Results_block_info() {
  // This example comes from node.module.
  $blocks['Rower_Results_form'] = array(
    'info' => t('Rower Results'),
    'cache' => DRUPAL_NO_CACHE,
  );

  return $blocks;
}

function Rower_Results_block_view($delta = '') {
  // This example is adapted from node.module.
  $block = array();

  switch ($delta) {
    case 'Rower_Results_form':
      $block['subject'] = t('Rower Results');
      $block['content'] = drupal_get_form('Rower_Results_form');
      break;
  }
  return $block;
}

 
function Rower_Results_menu(){	
	$items = array();
	$items['Rower_Results'] = array(
		'title' => "Rower Results",
		'page callback' => "Rower_Results_personal_info", // after visit drupal6/person, person_personal_info() function is called
		'access callback' => true, // must return true, otherwise it will not visible as menu item
		'type' => MENU_NORMAL_ITEM, // drupal's default menu type
		'weight' => '10', // we want to display person link below in our nav menu
	);
	return $items; // finally, do not forget to return $items array
}
 
/**
 * Implements hook_form().
 */
function Rower_Results_form($form, &$form_state){
	$form = array();	
	
	$form['overview'] = array(
		'#markup' => t('This form allows you to enter results for rowers'),
		'#prefix' => '<h3>',
		'#suffix' => '</h3>',
	);
	
	$form['name'] = array(
		'#title' => t('Rower\'s Name'),
		'#description' => t('Enter the rower\'s name'),
		'#type' => 'textfield',
		'#required' => TRUE,
	);
	
	$form['team'] = array(
		'#title' => t('Rower\'s Team'),
		'#description' => t('Enter the team the rower rows for'),
		'#type' => 'textfield',
		'#required' => TRUE,
	);
	
	//$form['actions'] = array('#type' => 'actions');	
	$form['submit'] = array(
		'#type' => 'submit',
		'#value' => t('Submit'),
	);
	
	$form['#submit'][] = 'Rower_Results_form_submit';
	return $form;
}

/**
 * Validate Rower Results admin settings
 */
function Rower_Results_form_validate($form, &$form_state){
  // No validation yet, but this will cause the form to run this code before submitting
}

function Rower_Results_form_submit($form, &$form_state){	
	$result = db_insert('rower_results')
		->fields(array(
			'rowerName' => $form_state['values']['name'], 
			'rowerTeam' => $form_state['values']['team'],
// The follow are arbitrary values simply to get it working until I finish the form
			'rowerGender' => 'M',
			'erg1_distance' => '2000',
			'erg1_result' => '8:00.0',
			'erg2_distance' => '5000',
			'erg2_result' => '22:00.0'
			))
			->execute();
// This shows a success message with the values inputted into the form
	drupal_set_message(t('Your entry has been submitted: '.$form_state['values']['name'].' '.$form_state['values']['team']));
}

function hook_block_view($delta = ''){
// This displays the form in the block
	echo(drupal_render(&$form));	
}
?>